Totalling certain rows
I have a question about totaling data in tables. I have two sets of data from different time periods 2021 & 2023, and I'd like to sum the respective metrics for each. I have two different tables present that may aid in getting this solution done.
For the first image I want to add a column after the 2021-12-01 column to display the totals for the metrics for 2021 and then add another column at the end after the two 2023 columns to show the totals for the 2023 columns.
Second image same thing but in that format. Either table would work for us.
Am I able to do this? Or should I just suggest the use of two separate tables, one for 2021 campaign and one for 2023 campaign? Not sure how to proceed.
Best Answer
-
@jakebutterfield If you want to show the totals for each year, add a beast mode using the formula
YEAR(`Date`)
to extract the year from the date column. Then add that new beast mode to the pivot table in your second image in the rows in front of Date. The pivot table will add subtotals by year once you do this.2
Answers
-
@jakebutterfield If you want to show the totals for each year, add a beast mode using the formula
YEAR(`Date`)
to extract the year from the date column. Then add that new beast mode to the pivot table in your second image in the rows in front of Date. The pivot table will add subtotals by year once you do this.2 -
Thanks @MichelleH!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive