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