Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created one pivot table and one pivot chart. Both have two same dimensions(Zone,Date) but the table has one expression(Sum of Sales) where as the chart contains three expressions (Sum of Sales, 1st Quartile of Sales and 2nd Quartile of Sales) . Hence, In chart we need to select Zone to analyse the data date wise. But, when I am selecting a Zone its showing the graph properly but the Pivot table is showing the data only for the selected zone. I want to show the data for all the zones in the pivot table i.e. Zone selection (filer) will not impact the table but Graph will show the data for the selected zone . Can any one help on this please.
Use this expression for your pivot table where you want to ignore selection in Zone field
Sum({<Zone>} Sales)
It wont work, Because when I am clicking on any of the zone it showing only the selected zone as follows:
The table is as follows:
Normal:
Zone | 2014 | 2015 | 2016 | 2017 |
East | 224 | 226 | 228 | 230 |
North | 251 | 253 | 255 | 415 |
South | 216 | 218 | 220 | 403 |
West | 419 | 245 | 247 | 132 |
For example if I Select South Zone from the Zone filter. It is showing the table as follows:
Zone | 2014 | 2015 | 2016 | 2017 |
South | 216 | 218 | 220 | 403 |
My requirement is to display all the zone along with its data irrespective of zone selection. Basically I want to lock the entire table from zone filter.
Even if you use this?
Sum({<Zone>} Sales)
That can't be true... can you share a sample where you see this behavior?
Hi,
Would it not be
Sum({<Zone=>} Sales)
Mark
Same thing.... equal sign makes no difference
I never knew that, thanks.
Its personal preference, some people like to use it, but I tend to avoid it because already the expressions are fairly convoluted and I try to remove anything extra that I can from my expressions