Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
the % column
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.
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.
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.
Ok dim, here is the solution.
the % column
thank a lot!!!
you are amazing!
it does exactly what i want it to!!!