03856me
Active Member
- Joined
- Apr 4, 2008
- Messages
- 297
I need to multiply different columns in a pivot table.
Columns are grouped by Year/Values
Existing Calculations:
% of Total is the Volume
% of Sub Total is % of Row
$ Per Unit is Dollars / Volume
CY - PY is $ Per Unit shown as Difference in Year
I need an additional column showing (Year 2020 % of Total) X (Year 2021 $ Per Unit).
How can I multiply the results of a calculated field times the results of another calculated field?
Columns are grouped by Year/Values
Existing Calculations:
% of Total is the Volume
% of Sub Total is % of Row
$ Per Unit is Dollars / Volume
CY - PY is $ Per Unit shown as Difference in Year
I need an additional column showing (Year 2020 % of Total) X (Year 2021 $ Per Unit).
How can I multiply the results of a calculated field times the results of another calculated field?