Hi,
I have following data;
Social Date Value
Facebook 04/04/2012 30
Twitter 04/04/2012 5
Facebook 21/04/2012 32
Twitter 21/04/2012 7
Facebook 14/05/2012 35
Twitter 24/05/2012 6
Facebook 24/05/2012 40
Twitter 28/05/2012 10

I would like to display latest submission per social metrics using SSRS report.
Social May Value April Value
Facebook 40 32
Twitter 10 7

Thanks for you help in advanced.