Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

dFilter data

Copper Contributor

Hello everyone

 

i have an excel sheet that has 3 columns 

Departments, Applications, Severity

now each department uses all applications but each has different severity

i'm trying to filter the results and i created a table and inserted a slider and the results looks like this 

robrobrobrob_0-1676316177564.png

i was wondering if instead of having to write Dep1 next to each application, is there a way to such write one time Dep1 and let the severity show for that department and if i select Dep2 it shows me the severity of that department ? meaning column 3 should changed based on selection

 

thank you

1 Reply

@robrobrobrob 

The simplest approach may be to keep data as is, pivot, and then slice:

Patrick2788_0-1676321258325.png