Totals in pivot

Aspiring_Developer — Thu, 10 Feb 2022 13:28:07 GMT

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 .

Re: Totals in pivot

chris_djih — Mon, 14 Feb 2022 14:44:16 GMT

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>)

topic Totals in pivot in App Development

Totals in pivot

Re: Totals in pivot