How to show row wise calculated value in pivot table

[Aditya_Chitale]

Hi everyone, 

Is it possible to show row wise calculated value in qliksense pivot table ?

I have months as my dimension values(column). And added 3 measures namely: Target , SO Created and CRM Approved. 

I want to show NRR (YTD Sum Total / count of total months) for all available months at the end of the table by adding an extra column

[hic]

Isn't this just a variant of an accumulation? If so, you should be able to do it with the Above function.

If you have Month as dimension (and the chart sorted by dimension) and Sum(Target) as measure, you can add a column

      RangeSum(Above(Sum(Target),0,RowNo()))

to get the accumulated target value. And if you want this divided by # of months, you can do a

      RangeSum(Above(Sum(Target),0,RowNo())) / RowNo()

See also https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581

[vinieme12]

something like below

=sum(aggr( RangeSum(Above(Sum(somefield)/count(somefield),0,RowNo(total))) ,  (Month,(Numeric,ASCENDING))))