Hello -

I love pivot tables, but this one has me puzzled.

I have sales data and I have COGS data for a group of stores. I want to
create a pivot table that calculates my COGS % (and Gross Margin %).

Thanks for any help.

Marc