3 Replies Latest reply: Oct 17, 2016 10:47 PM by Sunny Talwar RSS

    How to aggregate base on unique field

    Ruby Otero

      hi i have this kind of table:

      i would like to display in pivot table the promo amt per cv_number and also display the sum(amount) per product.

      Let assume i have a thousand lines with promo_amt (which is referring to amt per cv_number) and we have also the per product charging of this per cv_number. Do i have to use set analysis? i want to have a multiple dimension for aggregation.

           

      cv_numberterritory_codepromo_amtstrProdcdamount
      5651510131,196.91560852,599.74
      5651510231,196.91750052,599.74
      5651510331,196.91560852,599.74
      5651510431,196.91750052,599.74
      5651510531,196.91560852,599.74
      5651510631,196.91750032,599.74
      5651510731,196.91560852,599.74
      5651510831,196.91750052,599.74
      5651510931,196.91560852,599.74
      5651511031,196.91750052,599.74
      5651511131,196.91560852,599.74
      5651511231,196.91750052,599.77