I've throughly read through at least 7 other posts that might be similar to my question but still don't know if my situation is the same.
I'm trying to summarize daily sales and sort based on which cash register they were rung up on.
If the sales were wrung up on Register1, then I need the sales and quantities to be summarized by groups called Departments, and sorted by Deptartment "A","B","C","D". (Details would be hidden, of course.)
If the sales were wrung up on Register2, then same as above but I needed them to be summarized and sorted by Department "B","C","A","D".
So there are only 2 possible arrangements of the sorts. They're constant. Its either one way or the other based totally on which Register the sales were made. I try to use "Group in specified order", but can't get it to do it based on a condition of another field.
Using Crystal XI Pro.
Thanks in advance.
Mike
I'm trying to summarize daily sales and sort based on which cash register they were rung up on.
If the sales were wrung up on Register1, then I need the sales and quantities to be summarized by groups called Departments, and sorted by Deptartment "A","B","C","D". (Details would be hidden, of course.)
If the sales were wrung up on Register2, then same as above but I needed them to be summarized and sorted by Department "B","C","A","D".
So there are only 2 possible arrangements of the sorts. They're constant. Its either one way or the other based totally on which Register the sales were made. I try to use "Group in specified order", but can't get it to do it based on a condition of another field.
Using Crystal XI Pro.
Thanks in advance.
Mike