John P

Posts: n/a

Pivot Table Grand Total wrong when using Formulas

I used a Formula in a Pivot Table and the the total for the formula Column
is INCORRECT as it reflects only one portion of the formula. My formula is
an "if statement" that if one field is "0" use the other preexisting field.
Is there a way to have the total reflelct all amounts and not just the total
of certain amounts??

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change Data In Pivot Table	John Calder	New Users to Excel	1	July 7th 05 10:41 PM
Pivot Table vs. Formulas	Eric	Excel Worksheet Functions	3	July 7th 05 06:28 PM
Pivot Table Problems	Rachel Gonsior	Excel Discussion (Misc queries)	3	March 21st 05 07:24 PM
formulas referencing pivot table cells	JW_WA	Excel Worksheet Functions	1	February 8th 05 12:52 AM
Pivot table, how do you exclude counting cells with formulas as a	Greg Bobak	Excel Worksheet Functions	4	November 4th 04 12:05 AM

All times are GMT +1. The time now is 09:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us