Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Trying to use RangeSum function to sum sales values based on the weeknum function. Basically, when I use this function, I would like the results to show value for last total week when used in table.
Example:
Date Weeknum New Measure
9/10: 5 Total from Week Four
9/11: 5 Total from Week Four
9/12: 6 Total from Week Five
9/13: 6 Total from Week Five... etc
Is there any way to achieve something similar to this, maybe using different functions? The expression I made did not produce proper values. Any help is appreciated.
Can you share sample data?