T
Ted Metro
I have a pivot table that shows invoices by week by month by division. I have
three rollups on my rows for each division- I have invoice total by count,
invoice total by dollars, and % of the total invoice dollar amount.
Is there an easy way to color code my subtotals without going all the way
down the list and doing it manually? I'd like to have all of my invoice
counts blue, all of the dollar amounts green, and the % of dollar amounts
yellow.
three rollups on my rows for each division- I have invoice total by count,
invoice total by dollars, and % of the total invoice dollar amount.
Is there an easy way to color code my subtotals without going all the way
down the list and doing it manually? I'd like to have all of my invoice
counts blue, all of the dollar amounts green, and the % of dollar amounts
yellow.