Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i am trying to display the first and last transaction per till per customer per day.
My fields are :
StoreNumber (Customer)
TillNo (Till)
transId (Transaction Id)
TransStartDate (Transaction Date)
Can anyone help please?
Hi,
Have a look at the firstsortedvalue() function. This may help you to achieve you requirement.
-Sridhar
Try to make a calculated dimension ....
- it might be slow -
Hi,
table1:
Load
StoreNumber (Customer)
TillNo (Till)
transId (Transaction Id)
TransStartDate (Transaction Date)
from table
join
load StoreNumber,min(TransStartDate),max(TransStartDate) resident table1
group by StoreNumber;
Try this method .
Regards ,
Perumal.A