Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
i want to do this the margen between sum( today() sales ) and sum( today()-7 sales ) by week
thanks for helps
i got it finally if this can help anyone
Sum(quantite)-Above(Sum(quantite))
above() function it return the value of previous ligne
May be this?
Dimension - Week
Expression -
Sum({<DateField = {"=Today()"}>} Sales)-Sum({<DateField = {"=Today()-7"}>} Sales)
thank you anil
i whant Something like that
What are the J4 and J7
Check the values / measures of J - 14 and j - 7. There you need to modify expression.
What is the format in Date_Test? What are the values in J field?
date_test is 'DD/MM/YYYY' , j-7 and j-14 are date_test-7 and date_test-14
this exctly what i want to do the margine between sum(quantite) for this week and the sum(quantitie) of previous week
thank you for help i'm reely stuck
any help please
i got it finally if this can help anyone
Sum(quantite)-Above(Sum(quantite))
above() function it return the value of previous ligne