Hello Everyone,
Could you please help me find another solution with the following: I have sums of Bytes that exceeds many gigabytes in a Pivot Table. I would like to "format" these long numbers in terabytes or, at least, in gigabytes So far, the only way I've found is by adding a calculated field where I do the unit conversion. By the way, I can't touch the initial data set to convert source values. Therefore, that unit conversion has to occur at the PT. In short, Bytes should be displayed in GB instead even if the source data is in Bytes.
Example:
[65465465172] Bytes should be displayed in the Pivot Table as [60.97] Gigabytes (65465465172/1024³ = 60.97)
Thank you in advance for your support.
Solvap
Could you please help me find another solution with the following: I have sums of Bytes that exceeds many gigabytes in a Pivot Table. I would like to "format" these long numbers in terabytes or, at least, in gigabytes So far, the only way I've found is by adding a calculated field where I do the unit conversion. By the way, I can't touch the initial data set to convert source values. Therefore, that unit conversion has to occur at the PT. In short, Bytes should be displayed in GB instead even if the source data is in Bytes.
Example:
[65465465172] Bytes should be displayed in the Pivot Table as [60.97] Gigabytes (65465465172/1024³ = 60.97)
Thank you in advance for your support.
Solvap