Grouping the Expressions

[#1]

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 ......

[Gysbert_Wassenaar]

See here for a solution.

[sushil353]

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