topic Re: Partial sum in pivot table in QlikView

Partial sum in pivot table

mvazquez — Wed, 28 Mar 2012 16:21:01 GMT

Hi All,

My pivot table is:

Thanks!!!

Wed, 28 Mar 2012 17:03:21 GMT

Try

if(Match(Dimensionality(),'0','1',), Rangesum(above(sum(Value)),0,rowno(total)),sum(Value))

mvazquez — Thu, 29 Mar 2012 08:14:45 GMT

Thanks marcsliving,

You can see that the formula does not work, I think it is rowno(TOTAL) is '-'.

sivarajs — Thu, 29 Mar 2012 09:34:40 GMT

What you want to show

mvazquez — Thu, 29 Mar 2012 09:43:43 GMT

I attached a image

thanks!