Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I spent hours but i don't find solution and i need your help please !
i would like to insert in my articles table the max date of sold articles from my vente table.
How to do that please ?
Many thanks
why do you want to add it into the article s table?
You can easily find it in ui if you have article as dimension and max(date) .
But if you really want it. Create a temp table which will find max per article and join it to the article table.
E.g.
Left join (articles)
Load articleid, max(datevente) as [Max Ventes]
Resident Ventes group by articleid
Codee is rough. I am typing on my phone but concept remains
why do you want to add it into the article s table?
You can easily find it in ui if you have article as dimension and max(date) .
But if you really want it. Create a temp table which will find max per article and join it to the article table.
E.g.
Left join (articles)
Load articleid, max(datevente) as [Max Ventes]
Resident Ventes group by articleid
Codee is rough. I am typing on my phone but concept remains
Many many thanks
Have a nice end of day ¨!
c.
I wanted to count the number of article not sold since 90 days
thanks to your answer i can now do it
All the best and thanks again
c.