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

    the variable using set analysis not working based on dimension value

    Chandrashekar Jakkula

      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