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 Quick Sight 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 Quick Sight 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 Quick Sight 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!
