This content has been marked as final.
Show 2 replies
-
1. Re: Show Sales Persons over 100% by Region?
Brian Cronin Jun 6, 2018 9:24 AM (in response to Nathan Lee)1 of 1 people found this helpfulTry creating a calculated field based on your % of Quota Achielved that looks like:
Sales Rep Quota
{Include [Sales Person]: [% of Quota Achieved}
Then another calculated field mirroring how you're doing above.
IF [Sales Rep Quota field you just crated] > 1.0 THEN
1
ELSE
0
END
-
2. Re: Show Sales Persons over 100% by Region?
Nathan Lee Jun 6, 2018 9:38 AM (in response to Brian Cronin)Outstanding. Thank you, Mr. Cronin.
"Include" did what I needed. I did just what you said, and it provided a correct answer. As a bonus, it even gives me an appropriate answer when I am displaying the Sales Person dimension.