Pivot Table Formula workaround needed For 2007 limitation for sum of

**smd747** · 02-07-2012, 08:32 PM

I am using excel 2007 and can not figure out how to actually sum each date group percentage group. It works for all other value groups except for my formula. It looks like a limitation in 2007. Does any one know a work around or can educate me, I have been going at this for days looking for a work around I did not see any other threads on this

I have attached a sample.

Thanks in advance for looking at it

**NBVC** · 02-08-2012, 09:48 AM

See here for reason behind the problem... http://www.pivot-table.com/excel-piv...d-field-totals

So calculate the $MET as part of the table (column G) (i.e with formula =F2/E2) if it is not already a hardcoded value... at the top and include in your Pivot Table data source. Then it will work.