Calculating Percent Change in a Pivot Table


My goal is to have the variance shown as a percent change from Last Year's Revenue in the pivot table. Is there a way to do this?
Best Answer
-
What does your beastmode look like?
to calculate this you can do one of the following.
((sum(rev this year) / sum(rev last year)) * 100)-100
or
((sum(rev this year) - sum(rev last year)) / sum(rev last year) and then format your column as a %
or
((sum(rev this year) - sum(rev last year)) / sum(rev last year) *100
0
Answers
-
Can you expand on this a bit more? It seems you already have variance as a % in your pivot table?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
This is the percentage of the total variance for the column. I am looking for the percentage change between This year and last year's revenue totals. For this example, it should be -15%, not 1.7%. The variance column that is displayed is only a placeholder.
0 -
What does your beastmode look like?
to calculate this you can do one of the following.
((sum(rev this year) / sum(rev last year)) * 100)-100
or
((sum(rev this year) - sum(rev last year)) / sum(rev last year) and then format your column as a %
or
((sum(rev this year) - sum(rev last year)) / sum(rev last year) *100
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 146 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive