Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day.
There is my model in attached file.
In load script i calculate max date, where quantity > 0 grouping by Spoits.
How can i calculate the same, but grouping by Spoints and ProductType?
Thank you!
Use the both the dimensions in group statement..
ex:
Group By Spoint,ProductType;
Use the both the dimensions in group statement..
ex:
Group By Spoint,ProductType;
Then write like
Join
Load
Spoint,
ProductType,
Date(Max(Date))
Resident Input Where Quantity>0 Group By Spoint,ProductType;
Hi,
Please find the attachment for the solution.