I didn't really follow all you're saying but the short answer to the question about A>0 is to create a formula like this:
IF A>0 THEN COUNT[Name-Selling]/COUNT[Name- All] ELSE (Do Something else) END.
If you post a sample packaged workbook with a little better explanation of what you're looking to accomplish, we'll be able to better help you.
Thanks for the reply. Unfortunately I cannot post the packaged workbook because it is confidential information and will require too much to change.
I tried your solution and am getting errors involving mixing aggregate and non-aggregate information. If I do SUM(A)>0 it doesn't get me what I want...
Basically, I want to only count a Name-Selling person if A>0 for that particular person. The SUM function is looking at the total A for the entire group, not by individual. Is there a function or solution that will let me find all the [Name-Selling]s when A>0? Then I can count those as you said.
try using MAX instead of SUM in the calculated field.
Audrey, all we need is 10 or so lines of your data, changed if necessary. See here: http://community.tableau.com/thread/121116
While it may be some work, trying to give you the right answer in the absence of real data is also some work.
Audrey, what Alex said. With a minor edit: "... is a LOT of work." Especially when you consider without data or a packaged workbook this is a typical Q&A exchange:
A: How's this?
Q: No I meant__
A: OK, how's this?
Q Well that's close, but...
A: OK, does this work?
Q: Yes, that's mostly it!
.... ad nauseum.
[Audrey, please don't take this post personally, it is just a conversation that gets posted over and over again on these forums. In fact I think most of us who answer questions, spend more time having this exchange than actually solving problems and answering questions.]
EDIT: See below!
EDIT #2: I just realized that the original question was asked in June 2012! Dang Donna, you're digging deep. I wonder if Audrey is still around...
Or: "Yes! that works. Now my real data set looks like this...."