How to compare Value Columns

JackB116
Member
in Beast Mode
Hi,
Beginner to DOMO so excuse the question.
I've created a Pivot table with 2022 sales vs 2023 preorder sales by account and would like to add in a % difference column at the end that shows whether an account is up or down for 2023. How do i go about adding that?
Tagged:
0
Best Answer
-
Thank Michelle this has worked perfectly!
0
Answers
-
@JackB116 I'd actually suggest changing your card from a Pivot Table to a Table chart type if you want to add calculations. You'd need to use beast modes for your 2022 and 2023 totals like this:
- sum(case when `Delivery Year` = '2022' then `GDP Net` else 0 end)
Then your % difference calculation would look like this:
- (
- sum(case when `Delivery Year` = '2023' then `GDP Net` else 0 end)
- -
- sum(case when `Delivery Year` = '2022' then `GDP Net` else 0 end)
- ) /
- sum(case when `Delivery Year` = '2022' then `GDP Net` else 0 end)
1 -
Thank Michelle this has worked perfectly!
0
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign InWelcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign InCategories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive