HI!
I've created a report that generates unit/$ orders by an account by style & color. Currently I have it set-up where I list all the styles and based on the account drop down selection the data populates.
I'm wondering how I can set it up where when you select the account only the styles ordered get listed with unit/$ data in correct month it wants it shipped. Thus eliminating all the empty cells and creating a shorter and more concise list.
Below is a snap shot of the report. The arrow shows where the data would populate and it would be all the data highlighted in yellow.
Capture 1.JPG
Big Thanks,
~S
Bookmarks