Calculate available Tills ?

[#1]

Hi,

I have a pivot Table containing no of tills at branch and the Sales Value for each active till, I need to know if there are any more tills available at the Branch to take sales. As per the Attached Image.

So im looking for an expression like BranchTillCount-Count(ActiveTills) Im getting incorrect values for the Count(TillNO) im guessing its counting the underlying values ?

ColinR

[#2 · Accepted solution]

Hi,

you can use aggr() for it.

Have a look at attached file.

Kind regards.

[#3]

Thanks very much for your time and the Example, I was struggling to do it with with set analysis

Colin R