Sorting and filtering complex data (with a pivot table)

Yes, thank you, with the exception of "electronics" it works perfectly.

Now if you could explain to me how it works?

P.S. I know VBA, I'm just not that well versed in it yet.