|Month-Yr||Jun 2015||Jun 2014||Jun 2015||Jun 2014||Jun 2015||Jun 2014||Jun 2015||Jun 2014||Jun 2015||Jun 2014||Jun 2015||Jun 2014|
|if(location = 'North',(sum(Cars sold))|
|if(location = 'South',(sum(Cars sold))|
|if(location = 'East',(sum(Cars sold))|
I have a pivot table and Locality is a dimenstion -so how do I get the total in this case? Even using the set analysis - i do not have a column for the Total - so i need to load a 'dummy' Locality?
You can try Show Partial Sums option in the Presentation tab to display the total. Select Partial Sum option for all the dimensions and check.
In presentation tab of Pivot table properties Show Partial Sums option is available. I think QV9 it is available, can you attach a sample file or screenshot of that tab.
You have to set the data as shown in attached file.
Later use the below script and create Pivot table. No need to use set analysis.
Hope it will help you.
load * ,Date([Month-Yr]) as Date;
(ooxml, embedded labels, table is Data);
Click on the Dimension and select the Show Partial Sum option. If you attach the sample then it would be easier to provide the solution.