S
ssparklite
Is there code that can calculate % of sales dynamically? Is there a way
to do this in pivot tables?
For my report I have hundreds of companies, and it is pretty tedious to
subtotal percents each time manually. I want a way to reference the
subtotals to calculate the % of sales.
Example:
Company Sales % of Sales
a 1
a 2
a 3
a total 6
b 5
b 6
b total 11
c 4
c 5
c 6
c 7
c total 22
to do this in pivot tables?
For my report I have hundreds of companies, and it is pretty tedious to
subtotal percents each time manually. I want a way to reference the
subtotals to calculate the % of sales.
Example:
Company Sales % of Sales
a 1
a 2
a 3
a total 6
b 5
b 6
b total 11
c 4
c 5
c 6
c 7
c total 22