@Max Yes, I created this calculation based on the formula you mentioned above but my ask is different. I want to create a calculated field under Total Units (PY) having a value of 334.1M against each record as per attached screenshot, the way I’ve 471.9M under Total Units (CY) against each record.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Get last year value (periodOverPeriodLastValue) in a PRE_AGG scope | 4 | 1318 | May 10, 2023 | |
| 前年比較で一部レコードの集計がずれる問題について | 7 | 115 | August 20, 2025 | |
| How to make QS to keep rolling over previous calculations | 4 | 79 | June 17, 2024 | |
| PeriodOverPeriodComparison - Desenvolvimento QuickSight | 2 | 42 | November 19, 2025 | |
| Year to date, Quarter to date Calc in Quick Sight | 3 | 137 | January 29, 2025 |