Hi Team,
We have a pivot table in a Tableau dashboard (which shows a metric for different years so that we can compare it) and we want to replicate in a Quicksight dashboard. I created a pivot table (as shown below) in quicksight but I want to flip the grouping order (i.e. firstly grouped by metric and then grouped by year inside the metric). How can I do this?
Regards,
Chabbil
Hello @chabbils, I think the way to resolve this would require altering the way your dataset is built. Since your 3 data points are set in their own columns, the pivot table doesn’t have a way to sort out grouping them the way you want. If you made a single column like GF_Options, that would return either the value for GF Visitors, GF Conversion Rate, or GF Firstdiscovery, then another called GF_Option_Type that would return the names for each group, this would fit easily into the pivot table.
You would enter the GF_Option_Type field first in your columns field well, followed by your date field. Then in your Values you would put GF_Options and it would group your values accordingly by category. That way QuickSight has a way to reference the grouping to achieve your desired output.
Something to note as well, if you want your dataset to remain as is because it is implemented on other visuals, you can create a new dataset specifically for formatting this pivot table.
Hello @chabbils, I am going to mark my previous response as a solution. If you have any further issues with this, or have any questions about the solution I suggested, please let me know and we can try to sort out the details. Thank you!
