Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've got a count of the number of Business Units and Companies (far right). What I want to do is aggregate these up by the VAT Number (far left). So for this example it should be 44 Business Companies on each row (instead of 40, 3 and 1). PFA the working example. Any help would be appreciated.
Sound like you need a partial total. No need for set analysis or Aggr(). Something like:
Count(TOTAL <[VAT Number]> ......
Sound like you need a partial total. No need for set analysis or Aggr(). Something like:
Count(TOTAL <[VAT Number]> ......