How do you perform a calculation within a pivot table?

muahmmad_zaidi

I have two rows on my pivot table—one for revenue and one for costs. Trying to get to profit.

Is there a way to perform the profit calculation using a beast mode, and then making that beast mode a row?

Picture attached for context.

Thanks!

GrantSmith

You can do a conditional beast mode to calculate your revenue or cost calculations and not use the type as a grouping

Revenue

CASE WHEN `Description` = 'Revenue' THEN `Actuals` ELSE 0 END

Cost

CASE WHEN `Description` <> 'Revenue' THEN `Actuals` ELSE 0 END

Profit

CASE WHEN `Description` = 'Revenue' THEN `Actuals` ELSE 0 END - CASE WHEN `Description` <> 'Revenue' THEN `Actuals` ELSE 0 END

MichelleH

@muahmmad_zaidi It looks like @marcel_luthi and @jguzman answered a similar question to this earlier this week. Take a look and see if this applies to what you're looking for

https://community-forums.domo.com/main/discussion/59452/how-to-add-gross-profit-row-into-profit-and-loss-pivot-table

GrantSmith

You can do a conditional beast mode to calculate your revenue or cost calculations and not use the type as a grouping

Revenue

CASE WHEN `Description` = 'Revenue' THEN `Actuals` ELSE 0 END

Cost

CASE WHEN `Description` <> 'Revenue' THEN `Actuals` ELSE 0 END

Profit

CASE WHEN `Description` = 'Revenue' THEN `Actuals` ELSE 0 END - CASE WHEN `Description` <> 'Revenue' THEN `Actuals` ELSE 0 END

MichelleH

@muahmmad_zaidi It looks like @marcel_luthi and @jguzman answered a similar question to this earlier this week. Take a look and see if this applies to what you're looking for

https://community-forums.domo.com/main/discussion/59452/how-to-add-gross-profit-row-into-profit-and-loss-pivot-table