Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
On my sheet I have two table boxes that have the exact same columns. However, the data in these boxes are different. I'm trying to generate a new Table box that gets the differences between the two table boxes. That is show me in another box what is in the first box that is not in the second box. In SQL its like SELECT ID FROM A WHERE A.ID NOT IN (SELECT ID FROM B). Please is this possible? Thanks.
Sure no problem. Here goes:
Create a straight table chart with dimension Tab1_customer_id and expression
=sum({<Tab1_customer_id /= p(Tab2_customer_id)>}1)
It works. THANK YOU. I'm really grateful.
Thank you so much but It takes alot of time too load. Like its really slow. ANything I can do?