1 Reply Latest reply: Oct 8, 2014 12:16 AM by Enrique Colomer RSS

    Aggregation Distinct

    Paulus Indra Salim

      Hello,

       

      I have this sample data.

       

      COST_STRUCTUREAmountW4CC
      Gas792,721W4CC14AF00
      Gas792,721W4CC15BN00
      Gas792,721W4CC15BU00
      Depresiasi786,488W4CC14AF00
      Depresiasi786,488W4CC15BN00
      Depresiasi786,488W4CC15BU00
      Gas540,492W4CC17CQ00
      Gas540,492W4CC17CQ00
      Gas540,492W4CC17CQ00
      Depresiasi536,242W4CC17CQ00
      Depresiasi536,242W4CC17CQ00
      Depresiasi536,242W4CC17CQ00

       

      So I want to create a chart to know how much di Sum(Distinct Amount) per W4CC, but the Dimension is COST_STRUCTURE.

      More or less, the chart will be like this :

      Cost StructureTotal Amount
      Gas2,918,655
      Depresiasi2,895,706

       

      Gas is From Amount W4CC15BU00 + W4CC14AF00 + W4CC15BN00 + W4CC17CQ00, but all of them is distinct by W4CC.

       

      Please help!

       

      Thanks


      Regards,

       

      Paulus Indra Salim.