5 of 5 people found this helpful
Create the following calculation:
if max([Update Date])=window_max(max([Update Date])) then 'show' else 'hide' end
Then, place this calculation on the rows shelf. Right click on it and select Compute Using-->Pane(Across). Then, right click on the 'hide' row and select Hide. Finally, right click on the calculation on the rows shelf again, and un-check Show Header.
Hope this helps!
Thank you! I thought I had tried that, but the table calc was calculating at the wrong level.
Thanks a lot that solution helped.:)