Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
something like below
=sum(aggr( RangeSum(Above(Sum(somefield)/count(somefield),0,RowNo(total))) , (Month,(Numeric,ASCENDING))))