Excel Pivot Table

Sankar1234

5 pts.

Tags:

Microsoft Excel

Pivot tables

Sir

I Using Excel Pivot Table

I Create Calculated Filed Formula is If(((total Debit-total Credit)>0),(Total Debit-Total Credit),0)

This Formula very perfect use

But Pivot Table Grand Total show the zero (0)

How Grand total sum run please tell me

Software/Hardware used:
windows xp office 2003

Asked: April 11, 2010 6:53 AM Last updated: April 12, 2010 3:26 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Send me notifications when members answer or reply to this question.

Discuss This Question: 2 Replies

There was an error processing your information. Please try again later.

Thanks. We'll let you know when a new response is added.

Send me notifications when members answer or reply to this question.

carlosdl Apr 12, 2010 3:26 PM GMT

It should work as you expect. Did you change data or add the formula after creating the table ? Just in case, remember that the pivot table has to be updated after changes have been done to the source data, and this is not done automatically (unless you have some VBA code to do it for you).

84,745 pointsBadges:

report
Excel Pivot Table Get Pivot Apr 13, 2010 2:47 PM GMT

[...] is the original post: Excel Pivot Table By pivot | category: pivot, pivot table | tags: create-calculated, credit, filed, [...]

0 pointsBadges:

report