Forum Discussion
kheldar
Sep 01, 2021Iron Contributor
Filtering Away Certain Duplicate Values in Pivot Data Source
Hello, I'm using Pivot Table and Slicer to filter data from a raw data source. Our employees work rotating shifts. Between those shifts there are overlap hours. I created a file to track their perfo...
- Sep 05, 2021
Changed the Name 1 to Name01
Sorted the dataset by Name and No. of Initial Moderation Tasks
created filter columns rank, count, subnum, ref
did a power query on dataset including filter columns
created 2 reference queries Top 2 and Bottoms queries
filtered out bottoms on Top 2 reference query
filtered out Top2 on Bottoms reference query
cheers