Only Partial Sum on Pivot Table

[farolito20]

How can I show only partial sum, without a total sum on pivot table?

[MayilVahanan · Accepted solution]

HI

Try like this

= if(RowNo() = 0 or IsNull(RowNo()),'', Sum(Sales))

In Presentation tab, Labels for Totals  = ''

Hope it helps

[farolito20]

Thanks