I want to visualize the following table about sales data.
Specifically, I want to group different columns withe different headers based on the product type.
But when I upload to QuickSight dataset and visualize it, it shows:
Is it possible to pull the type header out of the specific product header and visualize it as shown in screenshot 1?
Thank you!
Hi @luckymeow - I do not think it is possible in QuickSight now, as a work around solution, you can create a text field and do overlapping but it may not look good.
By saying that, let’s hear from other experts on this, tagging @David_Wong @sagmukhe for the same.
Regards - Sanjeeb
Hi @luckymeow,
Can you show how your raw unaggregated data looks like?
@David_Wong Hi Divid, This is my raw data (.CSV file) shown in excel.
This is my raw data (.CSV file) show in in VS code.
This is the QuickSight visualization I got after using my raw data:
May I know how to update my raw data or configure quicksight visualization to make it visualizes data as shown in Screenshot 1 in excel with a common header across several columns?
Thank you!
Hi @luckymeow,
You need to create your dataset in this format first:
Then, you’ll be able to create your desired pivot table easily:
Hi @David_Wong - cool, pivot is the only solution in this case.
Hi @luckymeow,
It’s been awhile since we last heard from you. Did you have any additional questions regarding your initial topic or did the responses above provide you with a solution?
If we do not hear back within the next 3 business days, I’ll go ahead and mark the solution.
Thank you!
