1 2 Previous Next 17 Replies Latest reply on Feb 3, 2016 6:26 AM by paul kessels

    Calculate delta between two dimensions with common values

    paul kessels

      Hi, I have been struggling with something that sound like a simple calculation to me, but haven't figured out how to do it yet.

       

      I have a dataset with customers. Each customer is a in customer segment. Between years, they might move between segments (change segment). I want to calculate the delta between the number of unique customers in each segment.

       

      Current Segment (countd of all customers in segments A to E):

       

      A3
      B5
      C7
      D14
      E153

       

       

      New Segment:

       

      A4
      B8
      C10
      D10
      E150

       

       

      What I now want to create is a table/graph with the following result:

       

      SegmentDelta
      A1
      B3
      C3
      D-4
      E-3

       

       

      I have added this sample set with 3 sheets to this post. First 2 sheets is easy, but who can help me in the right direction with the Delta calc?

        1 2 Previous Next