Google Data Studio – displaying a chart based on pivot table, without showing the pivot table?


My raw data is in Google Sheets, with one of the columns representing categories that should act as filter. As a tryout, we’ve created pivot tables in Sheets, and charts on those pivot tables.

Now I’ve got to recreate those charts as a Data Studio report.

Looked at some basic tutorials, but I’m probably missing something crucial:

  • If I use the pivot table data from Sheets as data source, then I can’t apply a filter on the categories (they are in the pivot tables).

  • If I create a pivot table in Data Studio on the raw data, I couldn’t find an option to (1) not show this pivot table and (2) use this pivot table as input for a chart.

Any help is appreciated.