Hi All, I have calculated YTD Units as periodToDateSumOverTime(sum(Units), {Reporting Date}, YEAR) and it’s showing correct values within each dimension (e.g. Gifting Experience, Reporting Date) but when I’m clicking on Show totals for rows, the YTD values shown (under Total) are incorrect (from Q1…

YTD Total is appearing incorrect in QS

chabbils May 29, 2023, 3:04pm 2

Hi @apjvinod, Can you please look into this?
Old post link (which got archived) : YTD Total is appearing incorrect in Quicksight

2 Likes

Topic		Replies	Views
YTD Total is appearing incorrect in Quicksight Q&A calculations	2	377	May 8, 2023
Adding YTD column to Quicksight Report Q&A dashboard , dataset , reports , Business-Intelligence-Engineer	4	77	October 17, 2024
Previous Year Total values (at Quarterly Level) in Quicksight Q&A error , calculations	10	1620	April 29, 2024
Year to date, Quarter to date Calc in Quick Sight Q&A analysis , calculations , Business-Intelligence-Engineer	3	119	January 29, 2025
How to create YTD, QTD, MTD calculation based on my daterecorded column? Q&A developer , Learning-Champion	4	71	September 23, 2025