How to create calculated items (Not calculated field) in pivot table dashboard

Rafi1470
Member
in Beast Mode
Hi All,
In excel, in pivot table we can create new row with the help of Calculated item option.
Is it possible in Domo in Similar way or any formula to create new row in pivot table dashboard?. Attached Excel file for your reference.
If anyone help me with screenshots, I will be more happy. Thank you so much.
0
Best Answer
Answers
-
If your dataset in Domo contains the fields Sales and Cost, you would create a beast mode in Analyzer that is simply Sales - Cost and label it Profit. You would then drag that into your pivot table rows or values section
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Hi Mark,
Thanks for your reply.
I have sales and cost in same columns. Now how to do it. I have many similar cases.
Particulars
Amt
Sales
100
Cost
70
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 655 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive