This content has been marked as final. Show 2 replies
I have below fields in as my fields in database.
[Report Year] = [2016,2015,2014,2013,2012]
[Report Month] = [1,2,3,4,5,6,7,8,9,10,11,12]
[Sales Profit] = [123, 456, 789]
[Store] = [TX, NJ, LA, NY, CA...]
[Indicator] = [Yes, No, ....] this is at [Report Month] monthly level.
I have a store MAP on which I am showing 'Sales Profit' for current year (yearly sales) . How can I show [Indicator] value for [Report Year] = current year & [Report Month] = current month on tool tip?
Issue is MAP shows measure which is at yearly level and I want to show [Indicator] which is at monthly level on tool tip of store