first use the LOD expression below to ID the sales ID that passed
then use this LOD to determine the % by sales office
Detail looks like this
and the summary like this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
passing rate_v10.3.twbx 186.5 KB