# How do you perform a calculation within a pivot table?

Options
Member

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!

## Best Answers

• Coach
Answer ✓
Options

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
```

**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
• Coach
Answer ✓
Options

@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

## Answers

• Coach
Answer ✓
Options

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
```

**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
• Coach
Answer ✓
Options

@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