This content has been marked as final. Show 4 replies
Do you mind to update couple of your old posts?1 person found this helpful
based on number of records you have shown in your table for customer earnings and category ...could you please post the desired report out put ...here?1 person found this helpful
as i see the data here will be summed up as
In Category A who earned something - 1 customer (A 1234)
In other Category who earned something - 3 customers
In other category unearned customers -- 2 (C1234, e1234)
category A & Other earned - 4 customers
Category A & others unearned -customers
is that correct??
Yes that is correct. Below is the expected output I am trying to get to.
| Category A | Other Category | Category A & Other Category | Earned | 100 | 120 | 100 | Unearned | 150 | 150 | 200 |
not getting ....it's confusing1 person found this helpful
Category A & and other category = Category A + Other category (for both earned and unearned)
but your report doesn't show this result. so some gap is there.
your table sample data has only 6 records, why the report output is showing customer count in 100s?
Edited by: user2534719 on Jan 30, 2013 6:25 PM
Edited by: user2534719 on Jan 30, 2013 6:26 PM