i have a problem which im strugling with.

 

I need to build a report which shows what price lists customers are on and whether the price list has shown increased sales.

 

Each customer account has 6 pricelist fields.  TL1, TL2, TL3, TL4, TL5, & TL6.

 

A customer can have NO pricelists allocated or ALL 6 pricelists allocated.

 

the Pricelists field value can range from 1 - 999.

 

I am only going to be using 30 different price list ranges. (400 - 430)

 

So,

 

I want to group by these 30 values, then show what customers have these values within there price lists.

 

example:

 

GROUPING

400 = trade price (Deep)

401 = trade price (killer)

402 = retail price (killer)

etc, etc....

 

3ROBOTAC

4FOWLEY

2DADS

 

 

 

If I have customer code , 3ROBOTAC and this customer has TL1 as 400, and TL2 as 402 and TL3 as 407, I would want the account code 3ROBOTAC to show in group all 3 of these groups within the report.

 

I need to somehow ammalgamate the 6 PriceLists (TL1 to TL6) then group.

 

I tried creating a formula: {customer.TL1} + {customer.TL2} etc etc... then grouped by this formula but it never worked.

 

 

Hope someone understands, and I hope i have explained my self a little. Please help me on this one.. im struggling lol!

 

All help greatly appreciated

 

 

 

michael