topic Re: Find First purchase month in App Development

Find First purchase month

Rambhupal — Tue, 25 Jun 2019 04:36:19 GMT

I want to calculate first purchase month. Please refer the attachment. we need reruirement1,2,3

PrashantSangle — Tue, 25 Jun 2019 04:40:43 GMT

use firstsortedValue()

for detail see in help menu.

Regards,

Prashant Sangle

saminea_ANZ — Tue, 25 Jun 2019 05:16:17 GMT

PFA..

I've created the field Month_For just to change the format from your data set

MonthName(Date#(Month,'MMMYYYY')) as Month_For

Expression is used

MonthName(Min(TOTAL <[Corp Parent]> {<Value={"=Sum(Value)>0"}>} Month_For))