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

Rafi1470

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.

Domo_Calculated items (Not calculated field).xlsx

trafalger

@Rafi1470 you could expand the beast mode a bit like this:

SUM(case when Particulars = 'Sales' then Amt else 0 end) - SUM(case when Particulars = 'Cost' then Amt else 0 end)

And then group it by order or invoice or whatever and it should give you profit!

MarkSnodgrass

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

Rafi1470

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

trafalger

@Rafi1470 you could expand the beast mode a bit like this:

SUM(case when Particulars = 'Sales' then Amt else 0 end) - SUM(case when Particulars = 'Cost' then Amt else 0 end)

And then group it by order or invoice or whatever and it should give you profit!