It worked.Thank you Asim Cholas.

Hi Arijit, Thank you, that helped. When I create a stacked graph based on the pivot table after following the above link, the segment column is not displaying all the values(4values) in the graph which is taking only one random value and displaying for given years. Any Idea what could be the reason? Thanks, Vijaya

I agree on what you all are saying, but client requirement is in that way. Thanks, Vijaya

client requirement is like that, so we had to design the analysis that way. Thanks, Vijaya

no we actually need them separately so that we can display all the measures for previous and next year automatically though the default selection is current year. if we make it one measure then we have to select multiple years in dashboard prompt. Thanks, Vijaya

the thing is, if we do in that way, we have to select previous, next year's in the dashboard prompt, the way we designed it is it shows previous, next year values automatically if we select the current year. but we are unable to enable respective year hierarchy on that as I said above. Thanks, Vijaya

I tried this solution, It worked. Thank you so much.