Discussions
How to do a sales report filtered by item "display name" contains "X"
Lets say that we sell all variety of toys and I want to make a report showing which footballs sell the best. Lets also assume that we don't use the word "football" in any of our "item name/number" fields because we ONLY put item numbers in the "item name/number" fields. We do however use the word "football" in both the "display name/code" and in the item "store display name" field.
So, how can I make a sales report that is filtered by "display name/code" contains "football" or by item "Store display name" contains "football"? Surely this is a basic operation. Why isn't "display name/code" or "Store display name" in the filter list? What is the work around?