% Change Columns in Pivot Table
Hi Dojo Community!
My team is trying to create a card for a customer that allows them to select a range of years and/or months to compare (they will most likely view one month at a time), apply additional filters as needed, and drill into the table.
The card should be structured like the screenshot below. There should be a % change column where each red arrow is. Note that this would always be a comparison to the previous year; the customer wouldn't be able to pick, for example, 2018 and 2022.
Does anyone know of a way to accomplish this without dataflows? If we can do it with a dataflow and still have the flexibility we need in filtering and drilling, that will work too.
- 10.7K All Categories
- 13 Getting Started in the Community
- 39 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board