2 Replies Latest reply: Apr 27, 2012 3:16 PM by Daniel Fleisher RSS

    Pivot table with range dimension

      Hi Dear comunity

       

      I need made a Pivot table with a range dimension. This is the original datatable

       

      AgeClassSubClassValue
      10AA1100
      20AA2200
      30CC2300
      60DD1400
      90FF2500

       

      The desired pivot table is:

       

      Range (Age)Value (Sum (Value))
      From 0 to 15100
      From 16 to 30500
      Up to 31900

       

      Thanks !!