Hi I have a sales data with customer name and location, invoice number, date, sales rep, product. I want to build a cluster column visual to show the sales by time series, then right click the column to drill down to different dimenstions i just mention as option, e.g. by product, by sales rep, by customer. either these three deminsion will drill through to individual page for that very view.
I think this will help business to understand what made up of the sales.
Alternative, if drill through with different options is too hard, how about having a page called sales analysis with column chart on top and pivot table at bottom. instead, By product, by sales rep, by customer will be a button there, so once click, it will automatic change the demnsional view in the chart and the table.
Any direcitional help will be really appreciate.
