Pivot Table and Calulated Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BerkshireGuy - 04 Feb 2008 19:27 GMT

In a Pivot table of mine, there is a field called StatusHeader. The
values can be Submitted, Closed Out, Paid, Reopened.

I need to create a custom calculation now called Net Closed Out, which
would be Closed Out - Reopened.

Please tell me this can be done within the pivot and I don't have to
add a column or modify the source data. ;)

Thanks,
Brian

Reply to this Message

Roger Govier - 04 Feb 2008 23:01 GMT

Hi Brian

You can create a Calculated Item, by clicking on Status Header, and
selecting Formula from the PT Toolbar.
Create the Field Net with formula of = Closed Out - Reopened.

Once you do this however, you cannot add Status Header to more than one area
of the PT.
You could add it to the Row area or Column area but choose another field as
the item to count in the Data area

Signature

Regards
Roger Govier

> In a Pivot table of mine, there is a field called StatusHeader. The
> values can be Submitted, Closed Out, Paid, Reopened.
[quoted text clipped - 7 lines]
> Thanks,
> Brian

Reply to this Message