The use of pivot tables

[Ntsikzoh]

Good day.

May i kindly ask for your assistance in in the use of pivot tables. i want to have my pivot table on an existing worksheet as illustrated in examples above. my challenge in choosing the location, when i try to put the location it says destination reference is not valid. 

kindly help me.

[#2]

@Ntsikzoh 

Did you intend to insert screenshots into your message?

Have you tried clicking in the Location box, then clicking in the top left cell of where you want the pivottable?

[#3]

@Hans Vogelaar 

Hello Hans. thank you very much, i managed.