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

[lakshmikandh]

First Table :

Channel, Month , Count

Second Table :

Channel, Month, Firstcount

Load two tables with same column names and create table in front end like

Channel, Month, Count/Firstcount