Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a report where I want to create an overview of Dynamics CRM opportunities in different categories for different customers. I want to have a list with customers names where the names are conditionally formatted based on whether they have an opportunity in a given category or not. It is important that I am able to slice on opportunity categories.
To Exemplify:
The report consists of a opportunity category slicer and a table with customer names. If I select a category, for instance Digital Building, the table should be updated such that all customers are visible, but only the customers who have one or more Digital Building opportunities are colored by conditional formatting. The same applies if I select another category, for instance Internet Telephony. I have tried to do this, but I have to create one measure for each opportunity and have one page per opportunity category. This is not an acceptable solution since we have very many categories.
Any suggestions?
+1 to the thread,
Im interested in that function
🙂
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |