Two column help in Pivot Table

[bossman71]

Hello all,

Me and my buddies always do a fun betting circle between all of us during football. So I tried to make a database to make it easy on us.

It looks like I got everything that I need I just cant seem to get one thing.

I would like to have a total of 2 drop downs in the pivot table.
- first I would like to make one drop down which would be the payments but for some reason the amount creates it own whole new dropdown
* this would be just like the breakdown tab where it would add the payments per date and overall which would update the overall grand total
- second is the breakdown of days/months/years (which I look to have got already)


Is this possible to do? Do i have to make 2 separate pivot tables? (If So I would still like all the data to updates both pivot tables upon editing)

***Also is there any way to add in the excel document to auto refresh the pivot table. I have to always click refresh it manually.

Can this be done?

Thank you very much for your help.

payment test ex.xlsx