Different columns in table every month

[Anonymous]

Hi Guys

I've got a table with the following columns ID, Subject , Q1, Q2, Q3, Q4

That's fine, so I'm building charts with the data from Q1, to Q4.

How can I automate next month, as I've done textbox expressions and charts for Q1 - 4, how can I automate the new columns Q5 with the expression and charts, charts and text boxes can be the same layout, I just need to populate an expression or table with the amount of Q I get each month, some can be 3 some can be 30 etc.  And the questions will not be q1, q2, q3 etc, they will be random text.

Is this possible? crosstables and pivot tables perhaps?

Thanks

[muthukumar77]

Hi,

Can you share sample data?

[Anonymous]

data in excel

[muthukumar77]

Hi,

Send data in excel.

[Anil_Babu_Samineni]

I am not sure I understand your requirement might be this

'Q' & ceil(month(datefield)/3) + rowno() as quarter

[Anonymous]

Sorry Anil, you are totally doing something else. see excel file.