How to create calculated items in pivot table dashboard
Hi All,
I am new to Domo application. Please help me on the below query.
In excel, in pivot table we can create new row with the help of Calculated item.
Is it possible in Domo in Similar way or any formula. Attached Excel file for your reference.
If anyone help me with screenshots, I will be more happy. Thank you so much.
Best Answer
-
Hi Rafi, use the pivot table chart in a card. Sales, Cost as rows with country as columns. Calculate Profit in a beast mode and add as row. Then in the chart properties be sure to select totals, then show total row and show total column.
IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!
0
Answers
-
Hi Rafi, use the pivot table chart in a card. Sales, Cost as rows with country as columns. Calculate Profit in a beast mode and add as row. Then in the chart properties be sure to select totals, then show total row and show total column.
IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!
0 -
Hi Pauljames,
Thanks for your clarification. Could you please help me to show the formula to be created under Calculated field.
0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 559 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 574 Beast Mode
- 12 App Studio
- 28 Variables
- 582 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 26 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 356 Distribute
- 95 Domo Everywhere
- 259 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive