Dynamic Dashboard

[Ehtisham Ali]

Hi All,

I have created a dynamic dashboard but I am unable to add a desired functionality to it.

I you go through the dashboard and select country from yellow cell a dashboard will automatically display its states and relevant data.

What I need is just after the states it show Grand Total, also dynamically.

Regards
Ali

 

[Asheesh]

Hi Ali - The easier way of doing it is to put the grand total column on top..

i.e. Unmerge the yellow cell...and put the dropdown in cell C2...then merge D2:E2..and use sum(d4:d100)..change the range as you deem fit..

 

[Asheesh]

btw see column U V W....

Will this help..

 

[Ehtisham Ali]

Hi Asheesh

thnks for your prompt reply and awesome idea.

also thnks for another gr8 solution