Add a column by regular intrval in Cross tab report

[Former Member]

Hi,

In my requirement we want to display the premium amount by quarter after every three months in cross tab report.

If I add a coulmn in cross tab it wil created after every month. Please help me to fix this.

Thanks.

[Former Member · Accepted solution]

Hi,

Create the cross Tab report as below and apply the break in Q, in that Q column just provide the formula as Sum(Sales) In (Q).
if you have Q object it fine, otherwise create a variable for quarter as below
Var_Qtr= if([Month] Inlsit(1;2;3);"Qtr1";if([Month] Inlist (4;5;6);"Qtr2";if([Month] Inlist (7;8;9);"Qtr3";if([Month] Inlist (10;11;12);"Qtr4"))))

Create the cross tab with two rows (Month & Qtr) one column (State) and drag the sales measure in data values place. now apply the break in Qtr row. then provide the formula in that column as Sum([Sales] in ([Qtr]))

Thanks,
Sakthi.

[Former Member]

Add a variable and make the output of the variable as Q1-2014 and so on..

And add that variable to the header along with the moth.

Then create a break on the Quarter variable on the header..

Then create a break footer on the quarter and add the sum into the footer which will show the quarterly values..