Chechking if all attributes of certain dimenstion exist in period

In performace point we have a scorecard, with different current month scores for each sales agent ex: profit, number of deals etc.

We want to add a score that will display if the agent had deals with all stores in period. We have a store dimension, but how can we check if all stores were used in the period for that agent?

We could add distinct count of stores. But how can we get the overall number of stores as a target?

July 9th, 2014 1:20pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics