Forum Discussion
List of Data in Row with names and other info how to display them their Team member automatically?
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:
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:
