Data Studio
2.1K members online now
2.1K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Pivot Table in Data Studio

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Google Data Studio question: I have a large Google Spreadsheet I'm working off of. Basically a master data dump from a data source. From there I have a bunch of additional sheets that are pivot tables of that master data set. With Google Data Studio, you can't import pivot table data. Are you able to manipulate Google Data Studio in a way that basically mimics pivot tables?

1 Expert replyverified_user

Pivot Table in Data Studio

[ Edited ]
Top Contributor
# 2
Top Contributor

EDIT: now available as a widget

 

Not at the moment.

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan

Pivot Table in Data Studio

Participant ✭ ✭ ☆
# 3
Participant ✭ ✭ ☆

It depends what you're trying to get at. You could use the table visualization kind of like a pivot. Load your Google Sheets data in as your data source and then put whatever values would be your row labels (in your pivot) into the dimensions field and the values into the metric field. You can then use a filter to filter down the data however you want. 

Pivot Table in Data Studio

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

+1 for this feature.   Smiley Happy 

Pivot Table in Data Studio

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

+1 for pivot table in data studio

Pivot Table in Data Studio

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

+1 for pivot in data studio

Pivot Table in Data Studio

Explorer ✭ ✭ ☆
# 7
Explorer ✭ ✭ ☆

Please vote here

 

https://issuetracker.google.com/issues/62400537

 

cheers

Pivot Table in Data Studio

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

Any updates regarding pivot tables & Data Studio?

Pivot Table in Data Studio

Visitor ✭ ✭ ✭
# 9
Visitor ✭ ✭ ✭

+1 for pivot in data studio

Pivot Table in Data Studio

Visitor ✭ ✭ ✭
# 10
Visitor ✭ ✭ ✭

+1 for pivot table