i have this pivot chart:
2 dimensions:
1 expression :
IF(dimension1 = 'first',
SUM({<base = {actual}>} Value1),
'XXXXXX')
For the XXXXX i want a different calculation .. XXXXXX should be the SUM of Value2. The problem with Value2 is that is not on a period level, but on a period YTD level. This while Value1 is on period level. So, i should convert this.
In a seperate chart, i'm using this expression:
=if(right(period,2)<>'01',Sum(Value2)-(above(Sum(Value2))),Sum(Value2))
This will give me the correct values ..
but i dont know how i can combine both. copy/past doesnt work.