1 of 1 people found this helpful
Please help me understand
I got this from your book for 2017
and this for 2018
What were your expectations
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.
This is because your Market dimension spans multiple years. I think you'll want a new field which sort of creates a new dimension for the combination of market and year. Create the following calculated field:
Then move this to the Detail card, replacing the existing Market pill.
I think that should do it. See the attached workbook.
If this resolves your issue, please mark this as the "correct answer." This will help others who may have similar problems in the future. Thanks!
Map (1).twbx 52.1 KB
As Jim noted, you could just add Zip Code to the detail card, but that will break up the map into each zip code. My guess is that you still want to keep the entire area as a single section, rather than breaking into individual zip codes.
This solved my problem! Thank you so much Ken! You are awesome!
Glad it helped, Emily!!