Please provide a sample workbook.
1 of 1 people found this helpful
Its a bit of a trick to achieve what you are looking for.
Step 1. - Create a Filled Map with your metric and state
Step 2. - Go to Map Menu and select - Map Layers
Step 3. - Under the option of Washout - Increase the percent to 85% - play around to see what works best
Step 4. - In Dashboard when you select Rep (Customer Name) you will see that only States highlight with Rev (Sales)
Hope this helps. If it does please mark it correct so others can benefit from it. Thank you.
Ankit, that was awesome. exactly what i needed. Thank you