Forum Discussion
Solved
Display data with different time duration together
I have to show weekly data in two years together, in which the data in previous year has 52 weeks, and the data in current year has YTD. I would like to know how to show them together like the picture below (green for prevous year, orange for current year). Thank you.
Okay, Thank you.
7 Replies
dqian,
Could you please share dummy data of your table? For the previous year, do you still want to calculate YTD?
Regards,
LydiaHi Lydia, thank you for your response. Below is my dummy data. I want to show the both 2017 and 2018 year's percentage together.
YEAR WEEK % 2017 2 81% 2017 3 91% 2017 4 54% 2017 5 48% 2017 6 67% 2017 9 81% 2017 11 25% 2017 13 61% 2017 15 80% 2017 16 45% 2017 17 77% 2017 18 72% 2017 19 52% 2017 21 100% 2017 22 48% 2017 23 75% 2017 24 20% 2017 25 49% 2017 26 77% 2017 27 73% 2017 28 29% 2017 29 58% 2017 30 78% 2017 31 56% 2017 32 48% 2017 33 71% 2017 34 83% 2017 35 94% 2017 36 57% 2017 37 60% 2017 38 61% 2017 39 90% 2017 40 58% 2017 41 72% 2017 42 69% 2017 43 61% 2017 44 55% 2017 45 47% 2017 46 54% 2017 47 51% 2017 48 48% 2017 49 48% 2017 50 72% 2017 51 54% 2017 52 37% 2018 1 44% 2018 2 61% 2018 3 52% 2018 4 61% 2018 5 42% 2018 6 51% 2018 7 33% 2018 8 10% 2018 10 50% 2018 11 41% 2018 12 45% 2018 13 84%
