Set Analysis and Aggregation

[shane_spencer]

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.

[jonathandienst · Accepted solution]

Sound like you need a partial total. No need for set analysis or Aggr(). Something like:

Count(TOTAL <[VAT Number]> ......