Calculations between subgroups of a dimension

[#1]

Hello

I currently have my 2016 Data, budget and past years in a dimension called Origin.

Im using a pivot table to see results,but i want to make calculations between this fields.

Any Clues?

[jonathandienst]

It might be useful if you provided some clues on what you would like to calculate...

[brunobertels]

Hi

you can make calculation between this fields by using the before() function :

mesure :

may be :

sum(MONTO MILES) - before(sum(MONTO MILES))

[#4]

@

Jonathan Dienst (a abel abad) hace 9 horas

It might be useful if you provided some clues on what you would like to calculate...

Im just looking to make this formulas :

Real 2016 / Budget 2016

Real 2016-Budget 2016

Real 2016 / Real 2015

[jonathandienst]

And how are the values Real 2016/2015 and budget 2016/2015 calculated? The value of responses you get will be directly proportional to the amount of information you provide.