Please find the attached workbook.
I have to pick sum of sales on last date for all the categories.
I used this formula and it gives correct values in cross-tab but not in trend chart.
For the trend chart it picks last available value. E.g.- For Appliance the actual value is 0 but the formula picks last available value 4621.29. I want to modify the formula so that it picks 0.
Need help on this issue.
Retrieving data ...