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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.