Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
amanjain57
Creator II
Creator II

How can I stop total for one columns of Pivot Table ?

Hello, 

I have a pivot table that has few columns. I added the total column that by default adds all the columns. 

But i want to stop it to add for one column. 

you can see the example below. 

clipboard_image_0.png

I have to stop the addition for Block Stock (the last line). 

Thanks 

Aman

Labels (1)
2 Replies
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

maybe try with

If(Dimensionality()<>0 or yourdimension<>the value that you want without total, yourexpression, ' ')

amanjain57
Creator II
Creator II
Author

Thanks for the reply, I tried this solution but in this case all the columns go blank. I just want Totals to go Blank