This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Description: I'm trying to create a custom sorting order for a pivot table in Looker Studio. My pivot table includes semester data with values such as "Fall 2024", "Summer 2024", "Spring 2024", and "Fall 2023, Summer 2023, spring 2023 and so on". I need these values to appear in a specific order: "Fall 2024" first, followed by "Summer 2024", then "Spring 2024", and so on.
Steps Taken:
I created a calculated field named Custom Semester Order in my data source using queries.
I added this Custom Semester Order the field to column section to the pivot table.
I used the Custom Semester Order field for sorting in ascending order.
Problem: I want to use the Custom Semester Order field only for sorting purposes and not display it in the pivot table. However, I’m not sure how to hide this field from being displayed while still using it for sorting.
Question: How can I configure my pivot table in Looker Studio to use the Custom Semester Order field for sorting without displaying it in the table itself? or how can i sort my values.
LinkedIn
Twitter
