Hi All
i still unable to achieve above. I have try the below :-
1) I Using pivots Table , it can have dynamic dimension, it can have sum(sales) measures by year. ( it unable display YTD LY Sales )
2) I use chart , it allow dynamic dimension , for measure I use valuelist, it can display LY YTD Vs YTD ( I need Table )
3) I try Table , it can not have dynamic dimension . The rest it can.
Hope some one can share if you have new alternative.
Paul