Set analysis inside the Aggr()

[mukesh19]

Hi all,

Can anyone help me how to use set analysis inside the Aggr()

Regards,

Mukesh

[sunny_talwar]

What is your expression what are you trying to do? Can you provide a sample?

[pradosh_thakur]

Set Analysis in the Aggr function

hope this helps you.

[shraddha_g · Accepted solution]

Syntax is

Aggr(Expression with Set analysis, Dimension)

[ishanbhatt]

Hey Mukesh,

Use below Expression syntax to implement Set Analysis in Aggr function.

=Aggr(Sum( {<EmpStatus={'Active'} >}Sales), SalesRep).

Change the Expression according to your data.

Thanks,

Ishan

[pradosh_thakur]

hi mukesh

let us know if you are satisfied with the answer by marking it correct or helpful or assume answered .if not please dont hesitate to ask more questions.

[ArchanaB]

Hi ,

How Can I apply set analysis to Dimensions used inside Aggr function . My formula is below :

aggr(RangeSum(ABOVE(Sum({<$(vSet),HACKETT_TEVA_SAVING={$(vExpFilterByHACKETT_TEVA)}>}SAVINGS_ACTUAL),0,RowNo())),SAVINGS_CATEGORY,ACTUAL_DATE)

I want to apply $(vSet) in set analysis to Actual_date dimension as well . I tried using it but it doesnt give me any output.