Dimensionality issue

[Anonymous]

All, help needed on Dimensionality in pivot table

cat1,cat2,ID,Orders

A1,A2,11,Executive

A1,A2,12,Nonexecutive

A1,A2,13,Executive,

B1,B2,11,NonExcecutive

C1,C2,12,Executive

need the

Dimensionality 3--Categories for Orders with Executive values as Yes and for nonexecutive as No

--for Dimensionlaity 2 -- it should display the No even if there is one No for Dimensionality 3

same for Dimensionality 1

Expected:

Cat1  Cat2        ID          Orders

A1                                   No

          A2                         No

                         11           Yes

                         12           No

                         13           Yes

[kakani87]

something like this ?

[Anonymous]

yes Kishore but with indent mode

[kakani87]

Can you explain  exactly Indent mode

[kakani87]

Any sample Screen shot

[Anonymous]

please check indent mode under Style tab

[kakani87 · Accepted solution]

Yes I understood

Check  partial sum in Presentation tab