When aleast there are sales show name?

[Mavericks334]

Hi,

I have created a pivot table using powerpivot. Where i want to display the name of the person where there is sales in a given month? To select the month i use a slicer.

My Tables are as follows

Table A:
Location
Sale Amount
Type of Sale
Date
Month_End

Table B
Sale Rep
Location

There is a relationship between Table B and Table A

In Row labels i have the sale rep name and in values i have sum of sales and count of sales. With filter being Monthend?

Any suggestions how could i get it to work.

Regards,
Renato.