1 Reply Latest reply: Nov 1, 2016 3:16 PM by Settu Periyasasamy RSS

    the variable using set analysis not working based on dimension value

    Chandrashekar Jakkula



      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




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


      Thanks  in Advance