Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 3 tables automatically joined in one fact table because all of them have the same fields (quantity, type and value)
Imagine this tables are product1, product2 and estimate.
I want to make chart that compares the value of product1+product2 with estimate in the dimensions...
Thank you in advance for any help you can give me.
Perhaps an expression like rangesum(sum({<Type={'product1'}>}value), sum({<Type={'product2'}>}value), -sum({<Type={'estimate'}>}value))