Solved: Only Partial Sum on Pivot Table - Qlik Community - 390880

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services | Qlik Help

Ask a Question

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

1 Solution

Accepted Solutions

HI

Try like this

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

In Presentation tab, Labels for Totals = ''

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies

HI

Try like this

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

In Presentation tab, Labels for Totals = ''

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Author

Thanks