I have been knee deep into pivot tables the last couple of days. I made a rough prototype in v0.dev on "real" data to understand it better and see how it would work with my design.