Hi
I've started 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 & Division drop down selection I'd like the data to populate.
So I'm wondering how I can set it up where when you select the Account and Division it only pulls only the styles ordered & related unit / $ amounts by month in the cells below. 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.
Ord Stat.JPG
Bookmarks