2 Replies Latest reply on Nov 7, 2016 7:48 AM by Vishal D

    Monthly value on yearly KPI

    Vishal D

      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