5 Replies Latest reply: Jun 18, 2018 1:13 AM by Rangam Seshadri RSS

    Need Help on using concatenated output

    Rangam Seshadri

      Hi All,

       

      I am using aggregation function to generate the maximum transaction date in each month and concatenating it to populate the list of available maximum date.

       

      Background: I have a cumulative data set wherein all the sales will be accumulated till the maximum invoice date in that particular month. Now, I need to populate the sales quantity for each month.

       

      vlistofMaxDates=concat(aggr(max([Invoice Date]),YearMonth) ,',')

       

      if(sum(Match([Invoice Date],$(vlistofMaxDates)))=>1,[Sales Quantity])

       

      Note: Month end is not the maximum date in every-month and not every Maximum transaction date in that month has maximum sales. I using this as chart measure.

       

      Please help me in resolving this issue.