Skip to Content
Jan 30, 2014 at 12:09 PM

Dynamic bex column structure for YTD


Hi All

I have 3 key figures and 0calmonth2 and year and 0calmonth

I have 2 scenerios

1 jan to Dec fixed structure ( I am assuming this can be achieved user calmonth2 as 12 columns ) and user variable as calyear.

structue need to show based on user month like if user will enter aug 2014 ( calmonth2 and year) I need 8 columns .

Please let me know hwo can I achieve?