This content has been marked as final.
Show 2 replies
-
Re: Partial sum in Pivot table
Marc Livingston Apr 23, 2012 11:55 AM (in response to Dinesh Kumar)For the second expression use if statement and dimensionality() to tell it not to total.
if(dimensionality()<>1, Sum([Selling Price]))
-
Partial sum in Pivot table
Dinesh Kumar Apr 23, 2012 1:21 PM (in response to Marc Livingston)Hi, I found solution using advanced aggregation mentioned in below link.
http://community.qlik.com/message/189352#189352
Thanks.
-