Pivot table in 2007 with bytes

  • Thread starter Thread starter Kim
  • Start date Start date
K

Kim

Is there a way to the pivot table print a sum of bytes as KiB, MiB or
GiB ?

The built-in options only allow percentages and the total sum bytes
makes for very long numbers or E+x numbers.
 
Kim, as bytes to KiB, MiB or GiB is just a case of conversion you could
simply add a calculated field.

For example, to have a column in your pivot table showing the Summed
bytes as KiBs do the following:

1) Place your cursor somewhere in your pivot table
2) Select 'Options' on the ribbon
3) Click on 'Formulas'
4) Click on 'Calculated Field'
5) Choose a field name, i.e. Total KiB
6) In the 'Formula' section type:

=SUM( )/1024

and between the two brackets enter your Bytes field name using 'Insert
Field)

Click OK.

Voila....total bytes as KiB
 
Back
Top