I have a crosstab query which increases in columns as a feed table is populated to include data for new periods in the year.
An example of the crosstab output is detailed below.....
Measure 01 02 03 etc (pput eriods in a year)
ABC 1 3 7
DEF 2 9 12
From the crosstab i am running a report but i want to automatically include every period as and when the crosstab adds them, is this possible?
Apologies if its not well explained as i am struggling for the right words.