Hello
I am using pivot table to show data.
for example, 2 metrics Sales and Ad Spend with 7 days data.
Currently it look like
Setting in Pivot table
Rows = Product name
Columns = Date
Values = Sales, Ad Spend
But we want to represent data as following
Is is possible to show data as per second image, I means main metrics will be on top and dates below each metric? How ?
Hello Rahul,
The closest i could easily get is as below though i am not sure if it suffice your need – hopefully partially… May be other members have some idea or work around.
Hope this helps.
Cheers,
Deep
Hi Deep, thanks for reply.
Sorry I had uploaded incorrect image as First image. Now I have uploaded correct one.
Yes , the output you shown Is same as “First Image”
But I need output as per “Second image” where Dates are shown/grouped under each metric like Sales.
any work around guys ?
Hi @rahul.kolage, sorry, currently this is not possible but it’s on feature request. At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have tagged this as a feature request. More features are being added on a regular basis, so please keep an eye on the What’s New / Blog . You can set up a Watching Alert by clicking on the bell icon.
Hi @rahul.kolage, please refer this maybe helpful: https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Grouped-Table-Pivot-Table-Headers for grouping headers.
