Skip to Content
0
Apr 24, 2014 at 09:28 AM

Last date in report

29 Views

Hi All,

I have a requirement where in i need to show the last transaction date that took place at sales org level.

following is my data in the cube
Sales org------plant---------transaction date
S001...........P100...........01.02.2014
S001...........P100...........03.02.2014
S001...........P200...........02.02.2014
S001...........P200...........04.02.2014
S001...........P200............06.02.2014
S001...........P200............08.02.2014
S001...........P300.............03.02.2014
S001...........P300.............04.02.2014

My report should display as below

S001....P100.......03.02.2013
s001....p200.......08.02.2014
s001....p300.......04.02.2014

Actually transaction date is characteristics. So i used formula variable with exception aggregation as last value on 0PLANT. I get X as result.
Any guidance is appreciated

Thanks

Sri