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.
Why is it that Jan week 4 is 20? How would you know how to distribute if it isn't Revenue/Weeks per entry?
Its jus an assumed value
Just use 'Week'&'-'&week(Datefield) as dimension it will be done
if you are completely satisfied then end this thread as Answered or Helpful answer
Retrieving data ...