Pivot Table Headings

[priyarane]

Hi Community,

I need to put headings like I have attached.

In the worksheet(Table) - Data, and Output work sheet - looking output like that.

[Digvijay_Singh]

See attached, almost matching

[priyarane]

Hi Digvijay,

In indent mode, total will come but as per my requirement I don't need total...is there any way to avoid total in indent mode

[#4 · Accepted solution]

Hi Priya,

I think it doesn't exist a simple solution to avoid total in indent mode.

You can try adding a test with dimensionality in your expression, but this solution will be bad for the display perfomances.

Example :

=if(Dimensionality()>1,

      sum(Field)

,'') // if total then change expression to empty string

[Digvijay_Singh]

As Benoit suggested you can do like this -

if(Dimensionality()=1,'',<Your Exp>)