1 Reply Latest reply: Feb 1, 2017 1:19 AM by Lakshmikandh Karthikeyan RSS

    Divide the Values between Two Tables

    Samuel Lin

      Hello all,

       

      I have two calculated pivot tables as:

       

      Marketing Channel     OrderMonth (Jan 2016, Feb 2016....)

      Channel1

      Channel2

      Channel3

       

       

      First Marketing Channel       FirstOrderMonth (Jan 2016, Feb 2016....)

      Channel1

      Channel2

      Channel3

       

      The first table has the count of all the customers by month and by channel

      The second table has the count of all the NEW customers by month and by first channel

       

      I would like to have a table that divides the second table by the first table, so I know the % of new, but these tables are based on different dimensions.

       

      Any thought?

       

      Thanks,

      Samuel