Custom row in a pivot table

[#1]

hi,

I have the following pivot table :

Header 1	Header 2
r1	100
r2	30
r3	50
r4	-
r5	90

I need to add in the pivot table a cell wich contain a custom expression where "Header 1=r4". the expression is in depending of other rows. for example :

r4 = r1 + r2 - r3. So my pivot table will be like this:

Header 1	Header 2
r1	100
r2	30
r3	50
r4	80
r5	90

Could you help me please to find a solution.

Regards,

Yacine

[erichshiino · Accepted solution]

you could write something like: ( I don't know the expression for Header2, I guess it is sum (Header2))

if( Header1='r4', sum( {<Header2 = {r1,r2}>} total Header2)-sum( {<Header2 = {r3}>} total Header2)

, sum(Header2) )

... but I think it may be difficult to write an expression to work in a more general situation..

Hope this helps for now,

Erich