Hello,
I have a very simple pivot table that shows me the sales volume of different stores (in the rows) for the months (Jan, Feb, Mar - in the columns). The table also shows me the Grand Total of Volumes for Jan, Feb, Mar, which I want to display as well. My goal now is to have an extra column at the end that puts a $ Value to the Volume of the Grand Total, using prices I have in my source data (different for each store). I have tried to just calculate the $ figures in my source data and then show it but this always ends up showing for every single month. However, I only want the $ figure for the sum of Jan, Feb, Mar. And that does not work.
Two solutions I came up with ( but did not work, maybe you have an idea):
1) I do add an extra column in the source data and somehow tell the pivot table to show only the grand total of that column summed up over the months.
2) I have a price list in my source data and using the grand total of the volume, i insert a calculated field that multiplies volumes and price.
Both did not work. I hope I explained the problem well enoguh and you can help me.
Cheers
I have a very simple pivot table that shows me the sales volume of different stores (in the rows) for the months (Jan, Feb, Mar - in the columns). The table also shows me the Grand Total of Volumes for Jan, Feb, Mar, which I want to display as well. My goal now is to have an extra column at the end that puts a $ Value to the Volume of the Grand Total, using prices I have in my source data (different for each store). I have tried to just calculate the $ figures in my source data and then show it but this always ends up showing for every single month. However, I only want the $ figure for the sum of Jan, Feb, Mar. And that does not work.
Two solutions I came up with ( but did not work, maybe you have an idea):
1) I do add an extra column in the source data and somehow tell the pivot table to show only the grand total of that column summed up over the months.
2) I have a price list in my source data and using the grand total of the volume, i insert a calculated field that multiplies volumes and price.
Both did not work. I hope I explained the problem well enoguh and you can help me.
Cheers
