3 Replies Latest reply: Dec 11, 2014 6:46 PM by Saradhi Balla RSS

    how to get total for a certain level

      Hi There,


      I have got a question regarding how to get total value for a certain level.


      For Example,


      I have the table  as followings:


      ALU    COLOR  STYLE SIZE  30DAY SALE Inventory  Months Supply

      00001   blue       2001     M      20                  100          5

      00002   white     2001     L       10                   30           3


      If I want to calculate the months supply in style level, meaning that we can ignore the difference of ALU, COLOR and SIZE.


      So the style level months supply is (100+30)/(20+10)=4.33


      How can I form a expression of this?


      Thank you so much!


      Best Regards,