How to get the first operation date?

[#1]

Dear Experts,

             I have several dates in my pivot table and I would like to know the first working date for each Id.

In here, The start operation date for Id-113 is 02.06.2015 & Id-117 is 05.06.205. What function is appropriate to get the first operation date in this process?

Best Regards,

Kyaw Myo Tun

[PrashantSangle]

Hi,

You can use FirstSortedValue() or Min()

Regards

[#3]

Dear Max dreamer,

            I have some aggregation functions on that pivot table and Kindly ask to get an example for that on text pane because I am using personal edition.

Best Regards,

Kyaw Myo Tun

[PrashantSangle]

Hi,

Do the following changes in script,

try like

TableTest:

Load

Your Existing Script

from tableNAme;

Left Join

Load ID,

Min(Date) as minDate

Resident of TableTest

group by ID;

Regards

Then use minDate in your chart.

Regards

[MarcoWedel]

FirstSortedValue(Total<Id> Date)

hope this helps

regards

Marco

[jagan]

Hi,

You can use this as expression

=Min(TOTAL <Id> Date)

Hope this helps you.

Regards,

Jagan.

[MarcoWedel]

maybe also possible:

Date(Min(Total<Id> Date))

regards

Marco