Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hello,
No it is not the case as i want to select India ,North and South these particular zones in my pivot table
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
please attach some samples
Thank you so much