Hi im trying to make an operation based on data filtered on screen, check screenshot below.
I have 2 chart filtered by date on screen and i want simply make “total A - Total b= profit”
How i can do that?
Math operations happen in the data editor. Then display the result with a component in the display builder.
We need to be able to see the data structure but the following quickly occurs to me:
-
create if column and condition when the date to be filtered matches the date of the data row show the amount
-
create a rollup sum towards this column, so that it shows the result of the filtering
1 Like