I am wondering if anyone has a good idea about how I might do this. I like the Store Snapshot Quantity List report in HQ Manager, however I do want to modify it a little. Since this report list all of the items 3 times. Once for each store. It makes the report seem excessively long, since some companies we have well over a 1000 Items for. Just wondering if someone might know a way to make this report print out each item only once and have 3 columns. 1 column for each store that under the column list the quantities. This would greatly reduce the length of the report and also give a nice side-by-side comparison for available quantities of each item at all 3 stores. I have been trying to do this with formulas under the appropriate Columns but no luck. Any suggestions will be greatly appreciated.
Thank you, Neil