I was trying to use <> logic when I set the data join and I found that the function of
"Open with Legacy Connection" is still not able to be used on MAC OS.
Is there anyone has the same issue as mine?
Hi,
As far as I know this option is not available for mac.
Hope this helps.
~Tushar
Jun 28, 2018 8:16 PM
I don't think it ever will be, it's tied to some "Microsoft only" technology that has never been ported to Mac.
The name of said technology is Joint-Engine-Technology (JET) and actually the reason why legacy connections are not available for Excel for Mac is because Access is not available for Mac and the JET engine is more or less the Access engine.
Thanks for all your kind responses. Indeed, it is not able to be used on MAC.
Fortunately, I found another resolution to exclude data without using "<" or ">" in the data connection setting window.
Anyone who has the same problem with me could try this to create a measure by adding a calculated field.
"COUNT(IF [metrics A]=[metrics A'] then null else [calculated metics C] end) "