sum per minimal date - set analysis

[#1]

Hi All,

could you please give me suggestion how to solve my problem?

I have data by date and i have some values in seperate table.

In pivot table I need dimension that changes from Year/Month/Week/Day. And I need to always select Value for the minimal day (not always 1st of the month/week -so it needs to be dynamic in the expression, cant be a flag in the script).

Month          Value                                                            e.g.

Feb               Value taken from the first date of Month          Value for 01.03

Mar                                                                                  Value for 03.03

April                                                                                 Value for 04.03

or

Week          Values for minimal day of Week

7

8

I tried:

sum({<date={"$(=min(date))"}>} Value), but that gives me only value in the first line of dimension.. ;/

I'll appreciate your help.

Tommy

[sunny_talwar · Accepted solution]

May be like this

FirstSortedValue(Value, -Date)

or

FirstSortedValue(Aggr(Sum(Value), Date), -Date)