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 ?
