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.