Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
mvazquez
Contributor III
Contributor III

Partial sum in pivot table

Hi All,

My pivot table is:

1



1.1



1.1.150 €


1.1.2100 €

1.2.



1.2.1-40 €
OKTOTAL
110 €
2



2.1



2.1.1-15 €
How do you do?TOTAL
95 € (NO -15 €)
3



3.1



3.1.1-10 €


3.1.230 €
How do you do?TOAL
115 € (NO 20 €)
TOTAL

115 €

Thanks!!!

4 Replies
Not applicable

Try

if(Match(Dimensionality(),'0','1',), Rangesum(above(sum(Value)),0,rowno(total)),sum(Value))

mvazquez
Contributor III
Contributor III
Author

Thanks marcsliving,

You can see that the formula does not work, I think it is rowno(TOTAL) is '-'.

           QlikCom.bmp

sivarajs
Specialist II
Specialist II

What you want to show

mvazquez
Contributor III
Contributor III
Author

I attached a image

thanks!

QlikCom.jpg