You mentioned pivot tables, so reporting tools may be more appropriate in your case. Say, you can keep using Google Sheets, and sync the worksheet with BI tool

You mentioned pivot tables, so reporting tools may be more appropriate in your case. Say, you can keep using Google Sheets, and sync the worksheet with BI tool that for various reports. A lot of totally free options here (including SeekTable, why not?..).