Totals in pivot

[Aspiring_Developer]

Hi All,

I have below table :-

Dimension - LOB

Measure - count(issue no) -open issue |  Sum(openaverage) - Wkg Days | Average - Column(2)/Column(1)

I have enabled total in the pivot table.

My requirement is to get an output like below :-

Here in the Avge column , the calculation is WkgDays/Open Issue. I have done the same in qlik using column(2)/column(1).

The problem is the last value in the "Avge" column i.e 12.90 is calculated as 1122/87 and these are grand total values .

I don't know how can I  create the same in qlik because I am not sure how to use these total values in my pivot and perform further calculation.

Can anyone please help ? I am stuck on it . 

[chris_djih]

You can have a different calculation for the totals if you use Dimensionality().
Dimensionality() gives you the hierarchy of you pivot (How many layers you are in).

If (Dimensionality() = 0, <Your calculation for the grand totals>, <your "normal" calculation>)