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.
|