7 Replies Latest reply: Sep 18, 2015 4:07 AM by Jonathan Dienst RSS

    Max month data

      Hi guys,

       

      in my excel I want to display sales of A or B by max month

      here for A sales by maxmnth is 10 , but for B sales by max month is 70.

      I am using sum({<Month={'$(vMaxmnth)'>}Sales) in exp and in dimension it is Customer.

      But for B it is working but for A it is not working.

      Any suggestion on this? If multiple mnth entetred for customer it should pick max mnth sales but if only one mnth entered it should take that particular row.

      Can you help me on this?