Pivot table relationship

[Matthew112]

Hi I have a sample file here that I need help creating a relationship for. I want my income table to show category and income, and expense table to show company and expenses. I want to have 1 year and and 1 month slicer controlling both pivottables. I can't seem to get the relationship right as I get duplicate values error. What am I not understanding about this? Any help would be great

 

[AlanSidman]

I believe that to make this work, you will need to append your expense table to your Income table and then pivot your data to two PTs. Then look at this link-->https://www.myexcelonline.com/blog/connect-slicers-to-multiple-excel-pivot-tables/

 

[Matthew112]

I am using user forms to add data to these tables, if I add it to the same table than I'm dealing with large gaps in my table as my user forms deal with last rows.

 

[AlanSidman]

Keep the tables separate and append them in Power Query. Once appended, you can then load them back to a Pivot Table and set up your slicers. If you update the separate tables, then click on Refresh All and the PT and PQ will update automatically.