Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys.....
How to group the expressions in the pivot table .... For Example ....
I have a pivot table with no dimension and 8 expressions .. i want to group the expressions say like
first 2 expresson as in 'Sales Group' , next 2 expressions as in Finance Group'' and so on and so forth ......
See here for a solution.
In the expression tab you have the option to group the expressions.
in your case you have 8 expressions. then click on expression no-2 and click on group.. it will be grouped with the expression 1..
now click on expression 4 and click on group.. it will be grouped with expression 3 and so on..
HTH
Sushil