Choose columns to sum - pivot table

[#1]

Hi,

I have  a base year for each process, that it is diferent each time, and I need to sum, all years that are not base.

For this, I have an expression:

if(

SecondaryDimensionality()=1,

bla bla bla ,

SUM(

  Aggr(

  ( Sum({$< VARIABLE={'BUDG_PROVISIONS'}, SCENARIO_MOODYS={'PROVISIONS_ICAAP_2015','Final_Results_ICAAP_2015'}, SCENARIO={B}, VARIABLE_YEAR=VARIABLE_YEAR -{"$(=Max(BASE_YEAR))"} >} VARIABLE_VALUE))

  , VARIABLE_YEAR,VARIABLE_SEGMENT,PROCESS)

  )

)

Thanks!

[swuehl · Accepted solution]

Set Analysis does not consider your dimension values.

Maybe use something like

if(

SecondaryDimensionality()=1,

bla bla bla ,

SUM(

  Aggr(

  ( Sum({$< VARIABLE={'BUDG_PROVISIONS'}, SCENARIO_MOODYS={'PROVISIONS_ICAAP_2015','Final_Results_ICAAP_2015'}, SCENARIO={B} >}

If(VARIABLE_YEAR>BASE_YEAR, VARIABLE_VALUE) ))

  , VARIABLE_YEAR,VARIABLE_SEGMENT,PROCESS)

  )

)

Or have a look at

Evaluating "sets" in the context of a dimension

for another approach