Calculated item in Domo

Rafi1470

How to create calculated item in Domo same like excel pivot

GrantSmith

You can utilize what Domo calls a Beast Mode or Calculated Field. You can refer to their documentation on the Knowledge Base as a good starting point:

https://domo-support.domo.com/s/article/360043429913?language=en_US

https://domo-support.domo.com/s/article/360043430053?language=en_US

https://domo-support.domo.com/s/article/360043429993?language=en_US

Also, Domo does provide a Pivot table for you to use as a visualization if you're needing that type of visualization.

https://domo-support.domo.com/s/article/360043429473?language=en_US

GrantSmith

You can utilize what Domo calls a Beast Mode or Calculated Field. You can refer to their documentation on the Knowledge Base as a good starting point:

https://domo-support.domo.com/s/article/360043429913?language=en_US

https://domo-support.domo.com/s/article/360043430053?language=en_US

https://domo-support.domo.com/s/article/360043429993?language=en_US

Also, Domo does provide a Pivot table for you to use as a visualization if you're needing that type of visualization.

https://domo-support.domo.com/s/article/360043429473?language=en_US

Rafi1470

Calculated field will help to create new column. But I required new row with existing rows.

Row 1 should have Sales

Row 2 should have Cost

Row 3 should calculate based on Row 1 and Row 2.

Attached the sample file.

Excel_Calculated items.xlsx

Rafi1470

Dears,

Can anyone help me to create formula under calculated field under pivot table chart. Attached excel file for your reference.