Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)