How can I get the min of date_created in dimension of pivot table.

[suvechha_b]

Hi All ,

How can I get the min of date_created in dimension of pivot table.

Sample eg ,

My requirement -

I want to display 2018-06-30 13:16:00 as Min Date Created.

Thanks

[tresesco · Accepted solution]

Use expression:

=Timestamp(Min(Total date_created))

[sunny_talwar]

Or this if you want minimum date by batch_ref

Aggr(Min(TOTAL <batch_ref> date_created), batch_ref, date_created)