Skip to Content
0
Former Member
Apr 25, 2014 at 12:28 PM

Automation in Dashboard

30 Views

Hi,

I have data in dashboard sheet. Say example

Name Catgy Id Qty
--------------------------
Sam 1 1 100
Sam 2 1 200
Sam 3 1 300
John 1 2 121
John 2 2 125
Peter 1 3 150
Peter 2 3 200
Peter 3 3 250
Sam 4 1 300
Sam 5 1 400
John 3 2 450
John 4 2 400
Peter 3 3 100
Peter 4 3 200

from above, name should be filtered automatically and display like below:

Name Catgy Id Qty
--------------------------
Sam 1 1 100
Sam 2 1 200
Sam 3 1 300
Sam 4 1 300
Sam 5 1 400
John 1 2 121
John 2 2 125
John 3 2 450
John 4 2 400
Peter 1 3 150
Peter 2 3 200
Peter 3 3 250
Peter 3 3 100
Peter 4 3 200

How to achieve this.

Also, i have created 3 piechart for all three names Sam, John and Peter. I have placed push button near each piechart. So once we click on push button, separate spreadsheet table(component) needs tobe open which contains data. Eg: In name 'sam' piechart, only 'sam' data should diplay in spreadsheet table, In 'John' piechart, only john data should be display in spreadsheet table(component).

Can anyone help.

Regards,

Rajesh