View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jason[_14_] Jason[_14_] is offline
external usenet poster
 
Posts: 21
Default Pivot table in 2007 with bytes

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




Kim wrote:
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.