Generate a table that compares data from different tables on different sheets

[Yonch]

Hi there,

I have a pretty complicated workbook I created, that takes data from my company's data systems, and analyzes them.
Also it's in Hebrew So I made a simplified english version that focuses on what I'm asking, I attached it.

So, I have three sheets, that each have a table with the same catagories, different data, and one has more rows. the tables are according to fiscal months.

I want to create a summerizing table that can tell me what was the progress in different catagories and various divisions (Age division, Group, City, etc.) acording to the months.. Tried getting them on the data model and relating them, power query and other methods.. None achieved the result I want.

Any Ideas?


Thanks!

[Glenn Kennedy]

I can't see what you want the desired output to look like. Please amend your sheet to show (manually) what you want. Otherwise we could be playing guessing games for ages...

Thanks for not posting in Hebrew, BtW!!

[Yonch]

Hi Glenn, thamks for the quick repley. I tried making something manualy.


In short, I want it to sum participants of each group acording to status (First timers, begginers and pros), and how many finalized payment, and I want the months to be the columns and the group, age division and city to all be filters.

I added a sheet with a manualy (and fabricated numbers also) example, but with no filters cause it isnt a pivot.

[sandy666]

You can try consolidate these three sheets via Alt+D+P
but this doesn't allow you to have months becaue there is no any column with date or month
It would be possible via PowerQuery then PivotTable

[Yonch]

I tried Power Query. couldnt make it work...

[sandy666]

give me a few

[sandy666]

is that what you want?

(PowerQuery & PivotTable)