0calmonth(variable) in rows and columns

I have requirement like Query output QUANTITY should display based on given input 0calmonth variable

               MONTH1  MONTH2  MONTH3 MONTH4 MONTH5 MONTH6 MONTH7 MONTH8 MONTH9 MONTH10 MONTH11 MONTH12

MONTH1   12
MONTH2                  15
MONTH3
MONTH4                                              89
MONTH5
MONTH6    34                                                                                            98                                 32

In column i need 12 months as fixed and in rows 6 months.

Could please anyone suggest the possible way to this

Sol:

You can use Calmonth in both rows and columns. Bex will allow you f you do like below:--

Put Calmonth in rows pane.

Create 12 KFs and restrict with calmonth offset values. But one problem here is, rows will also show 12 months if you have data for all 12 months.