Partial sum in pivot table

[mvazquez]

Hi All,

My pivot table is:

1
	1.1
		1.1.1	50 €
		1.1.2	100 €
	1.2.
		1.2.1	-40 €
OK	TOTAL		110 €
2
	2.1
		2.1.1	-15 €
How do you do?	TOTAL		95 € (NO -15 €)
3
	3.1
		3.1.1	-10 €
		3.1.2	30 €
How do you do?	TOAL		115 € (NO 20 €)
TOTAL			115 €

Thanks!!!

[#2]

Try

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

[mvazquez]

Thanks marcsliving,

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

          

[sivarajs]

What you want to show

[mvazquez]

I attached a image

thanks!