9 Replies Latest reply on Mar 5, 2012 9:34 AM by Kevin Andrist

    Noob on this calc..Dimension subgroups..??

    Kevin Andrist

      I'm a noob on some calculations and this is one of them.  I'm guessing this will be a no-brainer for someone...

       

      Attached is a file that contains the base data (cols A, B, C)  & a diagram (cols I-N) of what I'm trying to do.

       

      The numbers in col J is the sum of the Baseline (col A) P2W Transition (col B), W2W Transition (col B)..etc...use Excel-Filters to see the contents of cols A & B and I think it'll make sense what I'm trying to do.

       

      Thanks for any help,