Hi everyone, i hope u can help me!
I have a pivot table with 2 dimensions, example: 1-Letters, 2-Numbers. And i have also some expression but i think the problem is not there.
What i have is
Letter Numbers Expr1
A 13 100
14 100
16 100
----------------
B 21 50
31 50
51 50
---------------
C 15 50
61 50
91 50
---------------
The problem is i need to group item B and C as it was a unique item in the first dimension and then i need to explode it, they want to see item B and C as it was a single item but they also want to be able to explode then and see them as different items. (First Question)
Ex:
Letter Numbers Expr1
A 13 100
14 100
16 100
----------------
BC ( + ) 21 50
31 50
51 50
15 50
61 50
91 50
I need also to be able to see it like this:
Letter Numbers Expr1
A 13 100
14 100
16 100
----------------
BC ( + ) B 21 50
31 50
51 50
C 15 50
61 50
91 50
It is possible to create a view like this using pivot table? Hope you can help me...
