Is it possible to group values that are variable (i.e. not equal to ....)? I would like to group 10-12 customers (by cust number) as 'special customers' and the rest (not equal to the special cust numbers) as 'regular customers' and show their sales volume. Because there are so many and it changes so frequently, I would rather not have to group them 'by hand' every time the report is run. Any ideas? Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Grouping values of variable data.
- Thread starter zredwing
- Start date
In the report, Select Data -> Variables
Click on Customer
Press the Group button
Give the Group a name "Cust Group"
Then select Customers from the Left and press Add
Give the group on the right a name
Uncheck the "Create Group for unused values".
The "Cust Group" can then be used as a section break and any new customer will drop into a blank group.
Click on Customer
Press the Group button
Give the Group a name "Cust Group"
Then select Customers from the Left and press Add
Give the group on the right a name
Uncheck the "Create Group for unused values".
The "Cust Group" can then be used as a section break and any new customer will drop into a blank group.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question