Creating connection using Power Pivot

[lesfell]

Hello,

In my attached file, in the first 1st sheet it shows the number of slots taken per class. While the 2nd sheet shows the class size or limit per class. I want to show via pivot the number of slots left per class based on the count in the first sheet, or is there any other way of doing it ? Thanks in advance

 

[p45cal]

Sheet2, cell C2:

=B2-COUNTIF(Sheet1!$A$2:$A$43,A2)

copy down.

 

[lesfell]

Sheet2, cell C2:

=B2-COUNTIF(Sheet1!$A$2:$A$43,A2)

copy down.

Thanks for this, but the formula shows only the number of slots left per row in sheet 1, I want to know the number of slots left per class based on sheet 2 based on accumulated count per class in sheet 1 and so on. For example:

 

[p45cal]

In Sheet1 cell C2:

=VLOOKUP(A2,Sheet2!$A$2:$B$11,2,0)-SUMIF(A$2:A2,A2,B$2:B2)

copy down.