Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot table grand total issue

Pivot 126.PNG.png

Here in the pivot table for the final performance field i want grand total .... and the expression for the final performance for obtaining the 109 and 98 is         =if(RowNo()=0,[Coperate SLP]*Performance)     let me know what is the expression for grand total to be appeared at the end

2 Replies
ecolomer
Master II
Master II

if (Dimensionality()=0, [Coperate SLP]*[Performance)

Anonymous
Not applicable
Author

its not working actually see there i should get the values only from the

top subtotals but not grandtotals so i mutiplied by using rowno()=0.

On Sat, Dec 6, 2014 at 7:37 PM, Enrique Colomer <qcwebmaster@qlikview.com>