Probably. A pivot table is basically a way to turn on one of the dimensions of the sheet to make sense of the data. Like "show me all invoices, grouped by date and sum each group". It is effectively a query, in a way that makes sense for people working in spreadsheets.