Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a sheet that brings in data from two tables - both tables have an "amount" field.
Does anyone know how to subtract data on the fly while the report is rendering in the UI? This is not something that can be done when loading from the DB because you will not know which rows will be compared until the report is run.
I feel like using measures would work but I am unsure of the syntax...all example I see are aggregate functions (SUM, MIN, etc.)
Thanks
how your data model look like ?
you may have to provide some sample data.