Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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