PivotTable Data Series Formatting

[Jay]

Hi all,

I'm having no luck solving this problem, so if anyone can help me out, I'd
appreciate it greatly.

I have a PivotTable displaying the product of a group of information. By
product, I mean all values in the series multiplied together. This is called
YIELD.

I then need to find the DPMO, which (for the uninitiated, lucky you) is how
many times we mess up every 1 million times. The formula is (1-YIELD) *
1,000,000

I'm trying to find a way to calculate the DPMO dynamically. I can't
calculate the DPMO in the data and just use that as a field for the
PivotTable as that calculation would be wrong. It HAS to be calculated on
the product of YIELD, as the PRODUCT will change based on the fields the user
decides to view.

So what I'd like to do is format (somehow, this is were you come in) the
data series to pull from the data the product of YIELD, but display the DPMO.
Or also display the DPMO, like in a label above the bar.

I'm not too picky about how the DPMO is displayed, I'd just like to know if
there is ANY way to do it.

Any help is a godsend. If you need more information, let me know.

Thanks,
Jay

 

[Jon Peltier]

Jay -

Can you include DPMO in the pivot table as a calculated field?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______