How to show row Total as a Difference

Question & Answer
,
1

How do I show the total as the difference in a pivot table?

For example I have

Category Amount
Revenue 100
Expenses 90
EBIT 10

2

Hi @leungjoot,
Currently, there’s no way to change the total option in a pivot table to show a difference.
One work around you could consider is to create a calculated field for EBIT that gathers the difference and then add that to your pivot table.
Otherwise, if looking to achieve strictly on a total or subtotal line, I believe you will need to change your expense field values to negatives so that it can work within the current limitations.

1 Like
3

Hi @leungjoot,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

4

Thanks! I’m basically trying to do this. How do I create the calculated fields from one table to the other?

EBIT Question
EBIT Question818×286 5 KB

5

Hi @leungjoot,
This is a bit of a work around to achieve, but take a look at the attached Arena view, I put together a similar model and included some explanation in there as well.
You have to create ‘fake groups’ to get EBIT to populate along with Revenue and Expense which you can then use for your calculations.

How to show row Total as Difference

Let me know if you have any additional questions or if this works for your case!

1 Like
6

Thanks so much Brett! I’m really appreciate of you taking the time and effort to recreate this. This is truly above and beyond. I’ll definitely explore this in detail. Very much appreciated!

2 Likes