1 Reply Latest reply: Oct 31, 2014 6:24 AM by Gysbert Wassenaar RSS

    Need to show dublicate count in pivot table

    Settu Periyasamy

      I need to show the dublicate count in the pivot table. please see the below screen shot.

       

      Base Table
      Orgcust_nameNumberCondition
      10Cust11234Fixed
      10Cust11234Discount
      10Cust10000.49Fixed
      10Cust100000Discount
      10Cust101-4050Discount
      10Cust10158Discount
      10Cust1017Discount
      10Cust10170BDiscount
      10Cust10182Fixed
      10Cust10182Discount
      10Cust10189ADiscount
      10Cust102186.0250Fixed
      10Cust1-02267Fixed
      10Cust1026002Discount
      10Cust102739.0250Fixed
      10Cust1-0281Discount
      10Cust1-0283Discount
      10Cust1-0284Discount
      10Cust103Discount
      10Cust103Fixed

       

      Out put should be like the below. if the Number is dublicate, i need to show the total count in Discount and Fixed.

       

      Count
      Orgcust_nameNumberDiscountFixed
      10Cust10322
      10Cust1123422
      10Cust10000.491
      10Cust1000001
      10Cust101-40501
      10Cust101581
      10Cust10171
      10Cust10170B1
      10Cust1018222
      10Cust10189A1
      10Cust102186.02501
      10Cust1-022671
      10Cust10260021
      10Cust102739.02501
      10Cust1-02811
      10Cust1-02831
      10Cust1-02841

       

      Thank you.