I am showing the weekly replor of this year as well as previous year.
Dimention - Date
Expression : for current year
:for previous year
In screen shot 1 table , when table shows the previous year value at that date it will show current year value 0 that is right but i want only 1 value at a time.
So i want to make my report look like 2nd screen shot.Is it possible to show my report looks like 2nd screen shot.