Hi everybody , I create a pivot table with 3 dimensions and 1 expression.
Something like that :
Grp Customer | Customer Code | Customer Name | Quantity |
---|
000 | 10 | Adam | 100 |
000 | 20 | Josepe | 250 |
A00 | 10 | Jules | 22 |
When i "reduce" the dimension Grp Customer , I'll like to always show the others dimension .
By default all next dimension will be hidden
Default Result :
Grp Customer | Quantity |
---|
000 | 350 |
A00 | 22 |
Wanted Result :
Grp Customer | Customer Code | Customer Name | Quantity |
---|
000 | | | 250 |
A00 | | | 22 |
Some one can help me please ?