pivot table issue

[Anonymous]

Here in this pivot table..... i want performance total as (1*2)+(a*b) how can i write expression at performance....

[JonnyPoole]

Here is an example to get you started.

In this expression i could pick up the required total cells by using the dimensionality() function which returns 1's for the row grand totals.   In that case i am adding 2 different row subtotals together using SET ANALYSIS.  The grand total is a straight addition of the 2 percentages in the subtotals.  You can do this with any valid arithmetic.

if( Dimensionality() <> 0 , sum(Sales)/sum(total Sales) ,

  sum( {<Region={'North America'}>} total <Year> Sales) / sum (total Sales)

  +

  sum( {<Region={'Middle East'}>} total <Year> Sales) / sum (total Sales)

)

[Anonymous]

ya thank you very much .if there any issues i will ping u don't mine

please.

On Mon, Dec 1, 2014 at 10:15 PM, Jonathan Poole <qcwebmaster@qlikview.com>

[Anonymous]

Here in the performance tab it is like this check out.