Is it possible to achieve this excel equivalent analysis/calculation structure in QuickSight pivot tables? If not, what would be the best alternative approach?

[sujanaab]

I’m curious if we can get one-to-one migration for an analysis developed in MS Excel to equivalent one in QuickSight. I’m trying to recreate the attached Excel dashboard in QuickSight, specifically focusing on displaying current year and last year data, as well as current month versus last month data. However, I’m struggling to achieve a similar visual layout in QuickSight’s pivot table. My main question is whether QuickSight pivot tables can support this type of format and data comparison. If it’s possible, I’d appreciate guidance on how to structure the data and set up the pivot table to match the Excel format as closely as possible. I know we could use dashboard filters but stakeholders prefer the above visual as they’re used to. If QuickSight can’t replicate this exactly, I’m open to suggestions for alternative ways to present this information effectively within QuickSight’s capabilities. Attached is the excel format.

Thanks in Advance!

[apjvinod]

Hi @sujanaab

Can you please have look into this [post] , and it has clear examples of calculating different period based measures. (Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc))

In QuickSight every period calculation YTD/MoM/Prev-Month will be considered as separate metric and it gets computed based on the dimension & date field grouping .

For further support would recommend to upload sample data in Arena , and share with us your progress.

[sujanaab]

Thank you so much for sharing this!