Hello,
Can I calculate two values in the same data field in apivot table?
In my source data, in column A that is labelled “Sale”, Ihave 2 values “Int’l” and “Domestic”.
In column B that is labelled “Amount”, I have dollar values.
When I create a pivot table, I get only one field for ”Sale”so I cannot calculate the difference between Int’l and Domestic.
Thank you.
Can I calculate two values in the same data field in apivot table?
In my source data, in column A that is labelled “Sale”, Ihave 2 values “Int’l” and “Domestic”.
In column B that is labelled “Amount”, I have dollar values.
When I create a pivot table, I get only one field for ”Sale”so I cannot calculate the difference between Int’l and Domestic.
Thank you.