Set analysis in chart

[#1]

I need to have a set analysis function based on the dimension of the chart. I tried this and does not seem to work.

first column - CC is my dimension.

I have added 3 expression columns to make my question clear.

On row for CC 269, i was expcting column 4 to have 6457.182.

Please help!

[jagan]

Hi,

Try using this with Aggr().  try this expression

=Sum(Aggr(If(CCSPONSOR1 = [CC], Sum(ACTUALMANWEEKS), 0), CCSPONSOR1))

Hope this helps you.

Regards,

Jagan.

[Gysbert_Wassenaar · Accepted solution]

Set analysis expressions are evaluated per chart, not per row. So you can't use CC both as dimension in your chart and in your set analysis expression. You'll have to use hardcoded values or if statements. See here for more information.

[#4]

Hi Jagan,

No, that did not work. It gave exact same result as

=sum({1<CCSPONSOR1=CC>} ACTUALMANWEEKS)

Thanks

[#5]

Thanks!