Show values in pivot table from straight table based on listbox

[#1]

Hello,

In my attached document, i have three straight tables. Basket,visit,buy.

I only get data in them when i select a product from my barchart.

How can i do so my values are not hardcoded but selected from my eventtype listbox and shown in one table only (my pivot table)?

So i want to show values based on my eventtype (atm. they are hardcoded in)

hope someone can help!

[#2]

no one with any kinda of ideas how to do this?

I can provide more data if needed?

Just be specific:

I want the three straight tables, to show the same data in one straight or pivot table

But based on my listbox Eventtypes (due to my eventtypes can be different from customer to customer)