Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create a variable and set the value as that of the first expression. Use the variable in the set analysis for the second expression.
doesn't work as this requires a one value whereas the max value changes between values of the dimension
the value is a table and not one value; it changes on rows; so doesn't work
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.