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.