6 Replies Latest reply: Mar 20, 2017 11:17 PM by karthik Daibala RSS

    Set analysis with aggregation

    Davide Ducco

      Hi all,

      I'm facing with a set analysis problem.

      I want to compare for some given dimensions the same expression between the minimum and the maximum date in a pivot chart.

      I try to explain better.

      I have the following data model:

      Field AField BDateValue
      1AA01/01/20135
      2BB02/01/201310
      3CC03/01/201310
      1AB04/01/201310
      2AB05/01/201315
      1AC06/01/201320

      I want to obtain the following result:

      Field Asum({<Date=(min(Date))>}Value)sum({<Date=(max(Date))>}Value)
      1520
      21015
      31010

      But the above set analysis does not work because checks the minimum and the max between all date set and the result is not correct.

      I try also with FirstSortedValue, but it does not allow to aggregate value in a pivot chart.

      Any help?

      Thank you very much in advance.

      Davide