Counting a comparison between SUM and COUNT Expression

[#1]

Hi,
I've the foloowing problem.

I've a table with "Target" and "Sell" values divided by Seller and By Category

Seller	Category	Cat 01	Cat 02	Total
Seller 01	Sell	10	12	22
	Target	15	10	25
Seller 02	Sell	5	6	11
	Target	5	5	10

I would like to add a column (or row) saing How many target has been reached.
I found  that I could add "Target Reach" with "If (Sell>target, 1, 0)" is working for the Cats columns, but not for the Total (the one I really need)

Please note that Sell  = COUNT(ContractNr), and Target = SUM(Target)

Any idea?

Thank you

[#2]

Sorry I forgto to add...

the results for Seller01 should then be 0, 1, 1
for Seller 02 1, 1, 2

[Anonymous]

I'd recommend you upload sample data and files. It makes understanding the problem easier!

Regards

MultiView