This is what I want to make. I work for Kellogg's on a sales division. So I
have sales info (%shelf, %displays, etc), categories info (snacks, cereals,
etc), geographical data (territories, city), store formats (walmart, etc) and
time ranges.
So I want to make a file where I store all this data, month to month. And
then some wizard in excel in which you can select of all these info what you
want to see, and it automatically sorts the data in like pivot table in such
way and might show a table and a chart. I know this can be done because
before I worked at PG and they did this. Someone can tell me which tools
should I use? Any ideas? I need to learn how to do this! Thank you!