Show only final total in pivot table

[surajap123]

Hi All,

I have multiple dimensions in pivot table, so that i get grouped result for my rexpressions.

I only want to show final total for each expression in pivot table. I dont want to show each row level detail in the pivot table.

So, how can i hide all the rows and show only the final total amount(which we generally see in the bottom of the pivot table when we scroll to the end) of each expression column?

[SunilChauhan]

use  variable

for example

let var=sum(total Fieldname);

and use $(var ) in expression

[surajap123]

Hi Sunil,

What I understand is, i need to create a variable in qlikview script and use that variable in my pivot table in front end. Am i right?

[#4]

If you go to Settings -> Variable Overview, it'll allow you to add the variable

[SunilChauhan]

you can create either in script or in Variable overview(Ctrl+alt+V)

if want in script

set var=sum(total Fieldname); this will work for your scnanario i thing

or

let var=sum(total Fieldname);

or if want in variable overview

Ctrl+alt+v

then cliclk on add bttion-> name the variable and variable expression

hope this helps