Forum

Thanks Mynda, I worked this into my real data and it works perfectly.

When I open the example file there is an error with the measure saying that COUNT can't work with a string?

Hi Phil, Thanks, got it now.

Hi Mynda, Thanks for the response. I can't seem to download your attachment?

perfect thanks!

Hi Mynda, My original example was a bit misleading with only a couple of rows of data - Sorry about that. In my real data both tables will have di...

Hi Mynda, I've attached a mock up that show the two tables and what I want as the merged table. Hope that is clear?