PowerPivot Subtotals
I have a pivot table, shown in the attached image. The pivot table is summarizing multiple types of data, and it is causing the totals to not calculate how I need it to. Each Store could have multiple surveys, so there may be multiple rows for each store, this is causing the "Forecasted Hours" to be added multiple times for stores that have multiple surveys. How can I have it only sum up each store once if they have multiple surveys. I can do an average to get each individual store to Subtotal correctly, but that does not fix the grand total.
|