GetCurrentField in Set Analysis

[Anonymous]

Hi All,

We have a requirement, where in the expression, we have to ignore the dimension in the cyclic group in set analysis expression.

Suppose, the expression is sum({<dim1=>}vol), where the dim1 is present in cycle1.

So, we need something like -

sum({<GetCurrentField([cycle1])=>}vol)

We need it as there are around 6 dimensions, can anyone pls suggest.

Thanks & Regards,

MK

[alexandros17]

try with

sum({ $ <cycle1=>}vol)

[Anonymous]

nope, doesn't work...

I tried sum({ $ <cycle1=>}vol)

sum({ $ <[cycle1]=>}vol)

sum({ $ <(cycle1)=>}vol)

nothing work....

[Anonymous]

Hi

Try with '$' sign in set analysis as suggested by Alexandros17

[Anonymous]

can you please provide link for same...

[Anonymous]

Hi

Can you share sample application.

And you want to ignore dimensions in cyclic group ???

Your requirement is unclear for me .Can you please elaborate

Thanks

[sauliusr]

sum({<[$(=GetCurrentField([cycle1]))]>}vol)

[Kushal_Chawda]

try,

=sum({<$(vExclude)>}Sales2)

where vExclude = getcurrentfield([YourCyclicGroupName])

[Anonymous]

This might work

[Digvijay_Singh]

Try this(replace group field with yours) -

=Sum({<$(=GetCurrentField(Year_Month))=>}Sales)