Help with setting proper Dimensions on my Pivot Table
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...
This solve question one, right now i have the 'BC' item created, but after that i need also to be able to break the BC item so i can see B and C separated
And now? xD
Well, could be something like this
I have now the items
A
BC
D
is it possible when i click in BC item it break then into B and C like
A
B
C
D
and if i click again i will group then into BC this would solve this topic
