Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

How do you figure the product of numbers in a pivot chart in excel?

9/2/2008 8

9/2/2008 8

9/3/2008 8

9/4/2008 8

9/4/2008 8

9/4/2008 8

9/5/2008 8

9/5/2008 8

9/8/2008 8

9/19/2008 8

9/29/2008 6

9/29/2008 8

9/29/2008 8

9/30/2008 8 ---- These are units and 1 unit = .25

9/30/2008 4

In the pivot chart it counts the numbers in the cells as 1 not the actual number in the cell. I need to know how to calculate the actual data.

1 Answer

Relevance
  • 1 decade ago

    Calculating the actual data? Do you mean 8 + 8 + 8 ...etc., which you would need to change it from count to sum. Or, do you mean to (8 x .25) + (8 x .25) + ... etc.? I think more information is needed.

Still have questions? Get your answers by asking now.