Pivot (Data Items "Count" vs "Sum")
Excel2003 ... Pivot Chart Data Items appears to default to "Count" ... I wish
this to be "Sum" ... Is there a way to do this before dragging Items from the
Pivot Table Field List to the "Drop Data Items Here" Section ... or ... must
I do this 1x1 after moving to "Drop Data Items Here" Section.
Also ... if there is another option ... I will certainly entertain it ... :)
Thanks ... Kha
|