Drill Group in Set Analysis

[#1]

Hi All,

I have a set analysis formula I am using along the lines of:

sum({<Date = {"*"} >} Price)

I would like to replace the static Date in the formula with a Drill group. Does anyone know the correct syntax to replace the Date dimension with a "GetSelectedField(Date_Drill)"?

Any help is much appreciated!

Thanks

[calvindk]

Not sure if you can make the GetSelectedField work inside the set analysis, but you can surely do different set analysis based on the field.

Something like this:

If(GetCurrentField(DateDrill) = 'Date1', sum({<Date1 = {"*"} >} Price),

If(GetCurrentField(DateDrill) = 'Date2', sum({<Date2 = {"*"} >} Price),

3))

[Gysbert_Wassenaar · Accepted solution]

This should work: sum({<$(=GetSelectedField(Date_Drill))= {"*"} >} Price)