Pivot table to exclude data

Hello

I am trying to create a pivot table from an income list to create a membership list.

I.e.

In column A i have say 700 entries of differing income
In Column F I have a column entitled Membership

I have created a basic pivot table, no problem.
However I wish to filter it so that the list created from Column A only shows if there is a corresponding entry in Column F..

i.e.

col F
A......£10
B.......
C......£10
D
E
F......£10
G
H.....£10
I.....£10
J
K

currently it will show the same in the pivot table but I want it to just show
A......£10
C......£10
F.......£10
H.......£10
I.......£10

Does this make sense.. I am relatively new to excel.

Thanks.. Steve

Unfortunately that does not work

see enclosed two images
first one as it is
second one in pivot
what i want is all rows to disappear if there is no data in the right hand column

enclosed is an example.
it is not strictly as it would be in the final excel spreadsheet.
in the final excel spreadsheet it will be many different entries, but that is really irrelevant as the important thing is the membership fee and donation fees received which are in the pivot table.

Hi Etaf

Oh brilliant..
I did not understand how to apply the filters.. now you have given me the example, it is simple..
But as with everything in life its only simple if you know how!
Many thanks much appreciated. By the way how do I add a picture to my profile page?
Steve