Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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