1 2 Previous Next 18 Replies Latest reply on Nov 23, 2013 6:41 AM by Toby Jutras

    Grouping Dimensions by Aggregate Sums

    ryan.mcmillin

      Hello,

       

      I have medical data split out by individual over two years and want to be able to group individuals uniquely by year based on the sum of the expenses that the individual has accumulated for the given year (ex: $0-$29,999, $30,000-$49,999, etc). The group cannot be based on the sum over both years. I'm aware that I can just manually group the individuals myself, but if I upload new data, I'd like for it to populate/group correctly based on new data.

       

      Data Example:

       

      IndividualReporting PeriodPaid $
      A2012$20,000
      B2012$30,000
      C2012$15,000
      B2012$50,000
      C2012$100,000
      A2011$120,000
      B2011$20,000
      B2011$70,000

       

       

      How I would like it to look:

       

      Reporting Period2012201220112011
      Paid BandIndividualsPaid $IndividualsPaid $
      $0 - $49,9991$20,00000
      $50,000 - $99,9991$80,0001$90,000
      $100,000 - $199,9991$115,0001$120,000

       

       

      Thanks!

        1 2 Previous Next