Issue with calculated dimension in pivot table

[ferha_jafri]

Hello Everyone,

I need help i have to create a pivot table in whicth the hierarchy is as product name,product grouping,sbu,subdivision,div,zone in this i have to push the zone upwards and have to create 4 expression for current and previous MTD and current and previou YTD my issue is i have to reduce the data fileds in zone dimension as i have 10 zones in total and i want to show 3 zones in the upward direction,please help it is urgent.

Thanks in advance

Ferha Jafri

[ariel_klien]

Hi,

in the chart properties there is a tab "Dimension limits" (in QV 11)

you can chose how many row in the dimension you want to show... like Top 3.

hope this will help you.

BR

Ariel

[ferha_jafri]

Hello,

No it is not the case as i want to select India ,North and South these particular zones in my pivot table

[MayilVahanan · Accepted solution]

Hi

You can use in expression by using set analysis

= Sum({<Zones = {'India','North','South'}>}Sales)

Use in all the expressions in the chart

Hope tat helps

[nizamsha]

please attach some samples

[ferha_jafri]

Thank you so much