Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Locality | North | North | South | South | East | East | West | West | SE | SE | TOTAL | Total |
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 |
Cars sold | 68 | 62 | 73 | 72 | 209 | 191 | 128 | 155 | 60 | 56 | 538 | 536 |
Cars Paid | 61 | 70 | 60 | 62 | 204 | 183 | 133 | 156 | 67 | 43 | 525 | 514 |
if(location = 'North',(sum(Cars sold)) | ||||||||||||
or | ||||||||||||
if(location = 'South',(sum(Cars sold)) | ||||||||||||
or | ||||||||||||
if(location = 'East',(sum(Cars sold)) | ||||||||||||
or | ||||||||||||
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?
Thank you
Jo
Hi,
To fix the charts you need to select
Chart Properties -> Layout-> Uncheck Allow Move/Size option.
You can attach the sample file by using Use Advance Editor option in the Reply section.
You are not getting the total because you are not selecting the Show Partial Sums option.
Regards,
Jagan.
Ah ... the Show Partial sums option works for ONE Month and ALL Campuses
but not when there are 2 months Jun2014 and Jun 2015 and ALL Campuses.
Sorry about the images - but I am paranoid about privacy issues!
You need to select partial sums for all the dimensions. If you are using Calculated Dimension move it to script and use the new field in the chart.
Regards,
Jagan.
Can you close the thread if you get the answer?