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