Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if (Dimensionality()=0, [Coperate SLP]*[Performance)
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>