Is it possible to achieve this excel equivalent analysis/calculation structure in Quick Sight 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 Quick Sight 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
Current Year vs Previous Year Calculation Q&A analysis , calculations , Business-Intelligence-Engineer	3	476	May 24, 2024
Adding aggregates to pivot table Q&A analysis , formatting , feature-request	1	376	April 10, 2022
How to filter the aggregated view in Pivot? Q&A admin	6	82	November 9, 2024
Presenting a clearer period vs last period comparison in a table Q&A analysis , formatting , calculations	1	498	July 8, 2022
Visualize four months data in pivot and MoM for lastest two months Q&A calculations , pivot-table , Business-Intelligence-Engineer	6	343	January 22, 2024

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

Related topics