Forum Discussion
List of Data in Row with names and other info how to display them their Team member automatically?
hi
i have a data list of Name with other info, like dept etc. in the Data Tab
I like to display as a table to show by The Team Name to auto pickup the list of member and dept in to another tab "Team List"
also, I like to check if data is removed in the "Data" Tab, it will auto remove
what about a new team is included in the "Data" Tab, can it auto update to the "Team List"
Attached sample table.
I not sure how to pull with formula from the "Data" Tab to display teams with their members as it's row and Data provided is from other user.
Thank you
Hi bbsin
maybe you could use a Pivot table and a slicer. In the attached file, you will find an example.
The pivot table either shows shows the data for all departments:
Or only for the ones that you selected in the slicer.
(to see them all again, just click on the filter icon on the top right corner)
The advantage is, that when your data changes (new records, or removed records), you just need to do a right-click in the Pivot table and choose "Refresh" and you get all information uptodate.
And you can easily add additonal fields to the pivot table by just pulling them to the row area:
2 Replies
Hi bbsin
maybe you could use a Pivot table and a slicer. In the attached file, you will find an example.
The pivot table either shows shows the data for all departments:
Or only for the ones that you selected in the slicer.
(to see them all again, just click on the filter icon on the top right corner)
The advantage is, that when your data changes (new records, or removed records), you just need to do a right-click in the Pivot table and choose "Refresh" and you get all information uptodate.
And you can easily add additonal fields to the pivot table by just pulling them to the row area:
- Thank you
