Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I show only partial sum, without a total sum on pivot table?
HI
Try like this
= if(RowNo() = 0 or IsNull(RowNo()),'', Sum(Sales))
In Presentation tab, Labels for Totals = ''
Hope it helps
HI
Try like this
= if(RowNo() = 0 or IsNull(RowNo()),'', Sum(Sales))
In Presentation tab, Labels for Totals = ''
Hope it helps
Thanks