Week

[siva0606]

I have attached two excel files. Excel1 file is the table which i has. But, i want a table in the format which is in Excel2 nd file.

[hschultz]

Why is it that Jan week 4 is 20? How would you know how to distribute if it isn't Revenue/Weeks per entry?

[sujeetsingh · Accepted solution]

Siv ,

Just use 'Week'&'-'&week(Datefield) as dimension it will be done

[siva0606]

Hi schultz,

Its jus an assumed value

[siva0606]

Thank you

[sujeetsingh]

if you are completely satisfied then end this thread as Answered or Helpful answer

Thanks