Impossible layout with Pivot?

Re: Impossible layout with Pivot?

Howdy. Probably not the approach you want or need. But you can get close by adding two columns to your original data:

Column E, labeled in E1 as Count

Cell E2

=B2*SUMPRODUCT(($A$2:$A$11=$A2)*($B$2:$B$11=$B2))

Column F, labeled in F1 as Disc Total

Cell F2

=C2*E2

Copy both down, then increase the data base by changing through the Wizard to include E1:F11.

Then move those two items to be additional rows in your pivot.