Pivot table from DataModel > hpw to add a formula?

[babettedv]

Hi there,

I hope that someone can help me with the following:
I have a pivot table based on a DataModel.
I wuld like to show the Row subtotals as Actuals - Budget.
Now the row subtotal sums the two.
e.g. CARD009 total = 199 (2903 - 2704)

Is that possible?

Thanks a lot

 

[RoryA]

I'd suggest you create a measure for Actuals, another for Budget and then one for the difference.

 

[babettedv]

How can I add a Measure?
Thank you

 

[RoryA]

Right-click the table name in the Field List, and choose Add measure...
Enter a name for the measure and then the relevant formula. Here the formula will be something like:

=CALCULATE(SUM([value field name]),[row field name]="Actuals")

for example. Repeat for the Budget. Then your difference field formula will just be:

 =[Budget measure name]-[Actuals measure name]

substituting the relevant field/measure names in to all the formulas.