6 Replies Latest reply: Jan 24, 2013 8:50 AM by Dimitris Charalampou

# compare only common data from month vs month or quarter vs quarter

Hi there,

I have a table of customers that contains the customer infromation and a unique customer id for each one of them.

I want to compare the transactions between two time periods, months or quarters but only for the common customers that have a transaction in both of the selected two periods.

Any help would be great.

Thnak you in advance!!!

• ###### Re: compare only common data from month vs month or quarter vs quarter

Hi:

Create the table with your 2 expressions, sum({\$<Month={ActualMonth}>}ammount) and  sum({\$<Month={BeforeMonth}>}ammount).

In the table properties, presentation: Supress cero values.

• ###### Re: compare only common data from month vs month or quarter vs quarter

Hi there.

Thank you for your quick response.

I don't think you understood what i want to display exactly.

I want to select e. q1 in one selection and q2 of 2012 in the other and display in a table box the % difference in the number of transactions, with the customer name as the chart dimension, of the customers that performed transactions in both the selected time periods.

Customer 1 -40%

Customer 2 -50%

Customer 3 +10%

Customer 4 -30%

Customer 5 +20%

.

.

.

.

Customer n +30%

I hope i made it easier for you.

Thank you again.

• ###### Re: compare only common data from month vs month or quarter vs quarter

To make it more clear

Lets say that in february only 10 customers performed transactions

Customer A

Customer B

Customer C

Customer D

Customer E

Customer F

Customer G

Customer H

Customer I

Customer J

annd in march the following 7 customers performed transactions

Customer A

Customer K

Customer L

Customer M

Customer B

Customer D

Customer F

What i want to display is the comparison of only the 4 common customers between the two selected periods, meaning

Customer A

Customer B

Customer D

Customer F

and calculate the % difference in the number of transactions as i displayed in the previous post.

Thank you.

• ###### Re: compare only common data from month vs month or quarter vs quarter

Ok dim, here is the solution.

• ###### Re: compare only common data from month vs month or quarter vs quarter

the % column

• ###### Re: compare only common data from month vs month or quarter vs quarter

thank a lot!!!

you are amazing!

it does exactly what i want it to!!!