Hi, I have figures from a dataset that I need to carry out calculations on (addition, subtract etc). In the attached, columns 'CAP' and 'ITB Not Built' use different filters to get the final number.
All I need to do is add CAP and ITB Not Built together for each client.
Pipeline is just these two figures put together.
Balance is Target - Pipeline.
It's fairly straight forward, I can get all the data in individual cards but I wasn't sure on the best way to carry out these calculations?
Cheers!