Sorting a variable in a Pivot Table

Hi!

I have a pivot table of this structure :

- a dashboard sheet

- a tRef sheet, composed of company_id, company_name, sector

- a tData sheet composed of financial data and company_id

The purpose of the pivot table is to select a company, and the financial structure of it appear, it's quite simple, but since i have more than hundreds companies, i'm looking for a good way to select and sort them.

I want to try a sector sorting first, where you select a sector, and the only company on the bound sector appear, but i can't manage to do it as a satisfying way.

I tried Slicers but I don't really like it, and the filter from the Pivot table are not my tea.

I hope it's clear, do you have any proper way of doing this kind of manipulation?

Thanks!