Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Table

Pivot Table

ResolvedVersion Standard

Wed 5 Mar 2008, 15:58 Delegate Bronwynn said...

Bronwynn has attended:
Excel Intermediate course
Excel Advanced course

Pivot Table

When I create a pivot table when I bring across the inforamtin into the layout, why does it always say count of instead of sum of?

Sun 9 Mar 2008, 10:37 Trainer Rich said...

RE: Pivot Table

Hello

The default depends on where in the pivot table you put your data. If you have a column of dates for example and you drop them in the 'drop data items here' section then it will do a count because there is nothing to sum because you cannot sum dates. If you are putting something in this section which is the value you want to sum or count so numeric values then it should go to sum. If it does not then double click where it says count and it should bring up the screen that lets you select if you want count, sum etc.

thanks
Rich

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

Pivot Table

Pivot Table

RE: Pivot Table

Excel articles

Excel tip:

Generating Random Numbers