Hello All ,
Im having a huge problem with trying to do simple subtraction from my Total rows (not displayed in the window ) vs whats displayed in my window.
|build||Version||id||number of machines|
|12345||version 2 a||23||1|
I want to display in the next column 110 total rows - id and i will get the sum 110- 23 =
I have tried count(id) - total(count(id))) but i get an error that it cannot blend / aggregate the data
any help would be appreciated . I cannot attach a work book because it is sensitive information.
A mock up data set and what you need finally would help to start thinking process.