The first dimension isn't incomplete in customize multiple dimensions when I enable the "Indent Mode"

[uacg0009]

Hi all,

I have data like :

I want to do a pivot table using Indent mode to show my data, but I found it is a little strange when I use the Indent mode:

I did a normal pivot table:

and the expression is :

=if(DIM_CATE='A' AND DIM='TOT',1,

IF(DIM_CATE='A' AND DIM='NEW',2,

IF(DIM_CATE='A' AND DIM='EXI',3,

if(DIM_CATE='B' AND DIM='SKC1',4,

IF(DIM_CATE='B' AND DIM='SKC2',5,

IF(DIM_CATE='B' AND DIM='MKU1',6,

if(DIM_CATE='B' AND DIM='MKU2',7,

IF(DIM_CATE='B' AND DIM='FRG1',8,

IF(DIM_CATE='B' AND DIM='FRG2',9,

if(DIM_CATE='C' AND DIM='REA',10

))))))))))

if I enable the Indent mode, the table will be:

it is so strange, the A and B disappear, and I also found that even I didn't enable the Indent Mode,

when I use the normal mode and I use collapse all, the table only shows C:

is that my expression wrong? or is it a bug?

do you have any idea to solve that?

Thank you!

[amit_saini]

Hi Aiolos,

As per my knowledge you cannot set partial sums when this mode is active.

Thanks,
AS

[uacg0009]

Hi amit,

thank you for your answer, but actually I didn't enable the "Show Partial Sums". it is still not correct.

[uacg0009]

Any one have any idea to solve this Indent Mode problem?