topic Re: Pivot table grand total issue in QlikView

Pivot table grand total issue

Anonymous — Sat, 06 Dec 2014 15:23:47 GMT

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

Re: Pivot table grand total issue

ecolomer — Sat, 06 Dec 2014 15:36:33 GMT

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

Re: Pivot table grand total issue

Anonymous — Sat, 06 Dec 2014 15:40:12 GMT

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>