This content has been marked as final. Show 3 replies
Unable to past the screenshot on the forums message box. I have checked the filters and other stuff. Let me explain with an example wht is happening.
For example I have a report Spend Trends by Items, where I have Year, Spend, Year Ago Spend, Chg Year ago Spend, Change due to price, Change due to quantity, etc.. columns
This report is showing different years but for rest of the columns it is showing of total of all the year. Like for year 2003, 2004,2005 etc we spend 10,20,30 receptively. so report should show it as 2003 - 10,2004 - 20 & 2004 -30.
But it is right now showing like 2003 - spend 60, 2004 - spend 60 & 2005 - spend 60.