This is what table return:
Client Asset Fiscal Year
A 1 FY2013
A 1 FY2013
B 1 FY2013
B 1 FY2014
C 1 FY2014
C 1 FY2014
A 1 FY2014
A 1 FY2014
B 1 FY2014
All assets are same in example.
So, there are two Fiscal Years:
2013 returns 1 because there is Client A that has 2 trades for same asset (B has one so it's 0).
2014 returns 3 because there are clients A, B and C with 2 trades each. If A had 10 more trades (for same asset), result would still be 3 because it count how many clients achieve 2 or more trades (and not how many trades there are).
Bookmarks