Hi
i have a problem hopefully im able explain it clearly here..
i used the running total function and each bar of my graph is increasing cumulatively. I want it to be more interactive whereby upon clicking on any of the bars, i am able to see another dashboard with more details. However, this is where im stuck.
for example, when i select the 3rd bar, it is the sum (running total) of 3 records. But when i right click to view data, it only reflected the 3rd record's amount. Hence when i tried using the actions function, regardless of whatever bar i selected, only 1 record is reflected rather than the cumulative records.
This is pretty urgent for my project. hope someone can help me. Thanks alot!
Hi
Not sure this is what you want but here goes - see the attached t10.1 workbook
it is a superstore example
I just used sales, then did a rolling sales and then a second rolling of the rolling - so 3 levels deep
There are 2 sheets one is a summary the other detail - summary is at the category date level - detail adds in the sub-category
so if I drag them both to a dashboard it looks like this -
When I select the date and category on the summary the detail looks like this
You can also use the filter to look at just the category
does this provide any help?
Jim
