Skip to Content
0

How to rank week numbers beginning from your first date in Reporting Period

Feb 17, 2017 at 04:08 PM

38

avatar image

Hi,

I'm looking at weekly sales and I have data from one year (RP) and previous year (CP). Now I might have to do this more than once and as I start my RP 2/2010-1/2017 I would like to put week number in right order: so first week would be week 5 then six and so on.

Does anyone have answer how I could do this?

Thanks for your answer.

Best regards

-K-

sap
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sasi Vemulapalli Feb 20, 2017 at 04:06 AM
0

Try storing week information in a calendar table in a database and use it.

Share
10 |10000 characters needed characters left characters exceeded