OK - Here is the deal:
I have a report that is pulls sales by item sub-totaled by ship to addresses.
The only problem is that there are 2 ship to addresses for the same store.
The first designates if it came from our warehouse
The second designates it was shipped directly from the mfg
These are: AAA (from our warehouse)
X-AAA (direct ship)
(this was not my design - by the way)
I would like the report (pulled from a unix server) that can total both shipments.
I know that interval grouping will do the left to right grouping, BUT CAN I HAVE INTERVAL GROUPING THAT WILL IGNORE THE FIRST 2 CHARACTERS?
Any help would be appreciated
Thanks,
Jeb
I have a report that is pulls sales by item sub-totaled by ship to addresses.
The only problem is that there are 2 ship to addresses for the same store.
The first designates if it came from our warehouse
The second designates it was shipped directly from the mfg
These are: AAA (from our warehouse)
X-AAA (direct ship)
(this was not my design - by the way)
I would like the report (pulled from a unix server) that can total both shipments.
I know that interval grouping will do the left to right grouping, BUT CAN I HAVE INTERVAL GROUPING THAT WILL IGNORE THE FIRST 2 CHARACTERS?
Any help would be appreciated
Thanks,
Jeb
