Doing an overall total in a pivot table using the Partial Sums option

[#1]

Hi

I have a pivot table in a QlikView document. Please see image.

If you look at the 'Total' column in the table, this is created by the Partial Sums option in the Pivot Table. This is fine. The total is displayed.

When I make selections in my document, the total changes. I want to be able to have a total in the table that when I make a selection I have an overall total.

Is there a way to do this?

Thanks

[jerem1234]

Please find attached to see if it is what you want. I used this expression:

if(secondarydimensionality(), sum(Value), sum({1}Value))

Hope this helps!