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

apjvinod · July 30, 2025, 8:31am

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.

Topic		Replies	Views
Adding aggregates to pivot table Q&A analysis , formatting , feature-request , how-to	1	363	April 10, 2022
Presenting a clearer period vs last period comparison in a table Q&A analysis , formatting , calculations	1	484	July 8, 2022
How can I build other visuals using data from the pivot table? Q&A analysis , visuals	4	1929	March 31, 2022
Current Year vs Previous Year Calculation Q&A analysis , calculations , Business-Intelligence-Engineer	3	395	May 24, 2024
Comparison with previous month while displaying all data for a month on Quicksight Q&A charts , analysis , how-to	5	3530	December 14, 2022

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

Related topics