Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, can anyone help me on how to display the sales for the last FULL week (MONDAY to SUNDAY).
I have sales being loaded in daily, On my chart i have a dimension that displays the sales for the date selected, but i also want a column next to it that displays the sales for the last full week. this figure should then stay the same until the next MONDAY where the figure will change to display sales for the previous week.
Is this possible?
Hi,
you can use the datefunktion week() and with set analysis you get the sales of the week before
Hi,
you can use Week(datefield) and with set analysis you get sales of the week before - pardon for entering it twice,
Ok thanks Martina, Do you have an example of the set analysis??