How to Transform Google Sheets Data to Display Metrics in Rows and Weeks in Columns in Looker Studio

[jamshed]

Hello Looker Studio Community,

I’m working on visualizing some data from Google Sheets, and I need help with formatting it in Google Looker Studio. Here's the situation:

Data in Google Sheets:

I have data structured as follows in Google Sheets:

Week Sales Impressions Clicks

2023-W01	1000	50,000	2,500
2023-W02	1200	45,000	2,800
2023-W03	900	48,000	2,400

Desired Format in Google Looker Studio:

I want to display this data in Google Looker Studio in the following format, where the metrics (Sales, Impressions, Clicks) are shown in rows, and the weeks (2023-W01, 2023-W02, 2023-W03) are displayed in columns:

Metric 2023-W01 2023-W02 2023-W03

Sales	1000	1200	900
Impressions	50,000	45,000	48,000
Clicks	2,500	2,800	2,400

What I’ve Tried:

I’ve connected my Google Sheets data to Looker Studio and set up a Pivot Table, but I am struggling with how to format the data such that:

• The metrics (Sales, Impressions, Clicks) are displayed as rows.
• The weeks (2023-W01, 2023-W02, 2023-W03) are displayed as columns.

I’ve tried adding the week in the Columns section and the metrics in the Rows section, but the output isn’t formatted as I want it and Row Dimension does not take more than two dimentions.

Questions:

1. How can I set up my pivot table to correctly display the metrics (Sales, Impressions, Clicks) in rows and the weeks in columns?
2. Is there a way to dynamically create the structure where the metrics and weeks are aligned this way using calculated fields or any specific configuration?

Any help or tips on how to format my data correctly in Looker Studio would be greatly appreciated!

Thank you in advance!