Set Analysis Help

[#1]

Hello! I am having a problem with a set analysis. I need the sum where Arrangement={'Hourly'} but I also need to give the alternative to whatever is selected.

Basically I am trying to add {$<Arrangement={'Hourly'>} to Sum({1-$}WIP_Total_Fees).

Thank you!!!

[sunny_talwar]

Alternative to whatever is selected? Not sure I understand....

With regards to adding the set in there, try this:

Sum({1-$<Arrangement={'Hourly'}>} WIP_Total_Fees)

[#3]

So there are filters and drill downs, and I need the alternative to what is selected by the filters/drills. I need the selected of Arrangement=Hourly to remain regardless.

[sunny_talwar]

May be this:

Sum({<Arrangement={'Hourly'}>} WIP_Total_Fees)

The above will filter based on all selections, except Arrangement which will always be Hourly

[#5]

But I need the alternative of the selections

[sunny_talwar]

I got it....

May be this:

Sum({1-$<Arrangement -= {'Hourly'}>} WIP_Total_Fees)

[#7]

I figured it out. Thanks!

[sunny_talwar]

What was it? Can you share with us?

[#9]

Sure. It was more that I was thinking about it the wrong way. I just did

Sum({$<Arrangement={'Hourly'}>}WIP_Total_Fees-WIP_Fees1)/Sum({1<Arrangement={'Hourly'}>}WIP_Total_Fees-WIP_Fees1)

And it accomplished the same thing.

Thanks!