I am using a pivot chart and have taken 3 dimensions i.e. name(needed only 3 names out of 10 names so hard coded in dimension), task(needed only 4 fields out of 10 fields so hard coded in dimension), priority(needed only 4 fields out of 6 fields so hard coded in dimension)..I have given an expression like count(task_No)...
In the attached image i.e. (values) u can see pending tickets column where can see 3 values for names..So that data is for today and tomorrow again it got reloaded means the values will be changing... Now my requirement if tomorrow the data got reloaded means the pending tickets values will be changing..So i want to see yesterday values and today values like that for a period of minimum 5 days..
