who is expert in set analysis

[ali_hijazi]

Hello I need an answer on set analysis syntax

I got a pivot table and 2 expressions
expression 1 is max({<man_days_type={"planned"}>} month_num)
expression 2 is sum({<month_num={">=$(fixed_start_month)"} man_days)

however in expression 2 I want to also include that month_num is <= to the value calculated in expression 1
kindly advise

[arpitkharkia]

Create a variable and set the value as that of the first expression. Use the variable in the set analysis for the second expression.

[raman_rastogi]

Try this
sum({<month_num={">=$(fixed_start_month) <=$(max({<man_days_type={"planned"}>} month_num))"} man_days)

[ali_hijazi]

doesn't work as this requires a one value whereas the max value changes between values of the dimension

[ali_hijazi]

the value is a table and not one value; it changes on rows; so doesn't work

[sunny_talwar]

If this is based on row value, then set analysis is not going to work because set analysis is performed at a chart level and not at a row level. May be use Aggr() function with an if condition.