How to create calculated items in pivot table dashboard

Rafi1470
Rafi1470 Member
in Beast Mode

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.

Domo forum.xlsx

Best Answer

  • pauljames
    pauljames Contributor
    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! 😎😎😎

Answers

  • pauljames
    pauljames Contributor
    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! 😎😎😎

  • Rafi1470
    Rafi1470 Member

    Hi Pauljames,

    Thanks for your clarification. Could you please help me to show the formula to be created under Calculated field.

Categories