Large amount of data into chart with options to filter?
Hi All,
I'd appreciate any help with the attached data.
Basically the data looks at sales of two brands in 3 territories which are also split down into sub territories and postal areas over a 12 month period.
What i'd like to be able to do is chart the data (pivot chart??) so that i can filter down by various options ( territory/sub territory/postal area etc) to be able to look at either individual brand sales or compare by the two brands in that particular option?
Any help would be greatly appreciated!!
FYI
Hi Chifans,
Please note that there was no attachment. To refer to your question, applying the pivot chart you reference will provide you the functionality of filtering down to any option you would like.
As a controlled workings, please refer to Answer - Large Amount of Data into Chart with options to filter.
Hope it helps,
Raymond