Lets say I have a Straight Table showing Item No, Desc and then YOY Sales and change. The item number will never change but sometimes the description will. This means showing YOY doesn't work so well if the desc have changed from one year to the next. I've tried using the TOTAL function and this works but then shows the same item and desc twice. All I want is to show the item once, then the most recent description ? Is this possible?
