the variable using set analysis not working based on dimension value

[#1]

Hi,

we created one variable with set analysis expression and the same variable using in pivot table expression but the value resulting on totality but we want the same to work based on the dimensions which we added in pivot table

find the below expression written in expression vDry :

sum( {1 < Product_Type={'-1'}, Material_Code={'DRY'} >} Amount_SAP )

/

sum( {1 <  Product_Type={'-1'}, Material_Code={'DRY'} >} Quantity )

The below expression using in pivot table which is having Plant_Code and MonthYear as dimension

=sum(aggr($(vDry),Plant_Code,MonthYear)

but the result is coming for all the months total but we require each month total individually

Thanks  in Advance

[settu_periasamy]

Hi,

Do you have the equal sign('=') in your variable, if yes remove that and try..

1) try without aggregation ,

2) and simplify the expression like below (check the values before and after expression update)

sum( {1 < Product_Type={'-1'}, Material_Code={'DRY'} >} Amount_SAP /Quantity)