Getpivotdata() with several elements for each field

[reitan]

I have some excel pivottable connected to a cube. The data are further used in excel by the getpivotdata() formula.

In the example below I have combined two getpivotdata() formulas to calculate the Budget variance. As you see the only difference of the "budget" and the "actuals" are the last element. "[Set].&[02.BGT]" vs "[Set].&[01.ACT]").

EXAMPLE:
Actuals =getpivotdata("[Measures].[Amount]";$A$6;"[TimeByYM]";"[TimeByYM].[Alle Måneder]";"[Set]";"[Set].&[01.ACT]")


Budget =getpivotdata("[Measures].[Amount]";$A$6;"[TimeByYM]";"[TimeByYM].[Alle Måneder]";"[Set]";"[Set].&[02.BGT]")

Budget variance =getpivotdata("[Measures].[Amount]";$A$6;"[TimeByYM]";"[TimeByYM].[Alle Måneder]";"[Set]";"[Set].&[01.ACT]") - getpivotdata("[Measures].[Amount]";$A$6;"[TimeByYM]";"[TimeByYM].[Alle Måneder]";"[Set]";"[Set].&[02.BGT]")


In more complex cases when I have to use 6-10 getpivotdata() formulas it is very difficult to read and maintain the formulas and mistakes may be done.

My Question:
=> Is it possible to make the formula shorter by using ony one getpivotdata() to get the budget variance?

For instance somthing like this?

=getpivotdata(....;;;;;"[Set].&[01.ACT] - [Set].&[02.BGT]")

in other cases I would like the sum of two departments wich are not grouped in the cube structure...
=getpivotdata(....;;;;;"[department].&[21] - [department].&[39]")

is this possible?

 

[reitan]

May I for instance use the addset method to calculate an new set called "budget variance"?

http://msdn.microsoft.com/en-us/library/bb209621.aspx