@Prav If you have an Author Pro license, you can leverage AI-powered prompts to generate calculations for your specific scenario. This calculation can be achieved using LAC-A (Level Aware Calculation - Aggregation) and LAC-W (Level Aware Calculation - Window) functions in QuickSight. Sample calculations are available in the link below for your reference.
Ashok
2
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| New to QS - Aggregating inside Calculated Fields for KPI | 14 | 906 | June 22, 2023 | |
| Replicate Calculated Fields from Tableau to Quicksight using FIXED LOD | 9 | 618 | January 19, 2024 | |
| Mirroring Total Function from Tableau to Quick Sight | 6 | 268 | July 9, 2024 | |
| Replicate Tableau's Fixed | 5 | 487 | June 6, 2023 | |
| Coonditional calculation in Quicksight | 9 | 234 | August 8, 2023 |