I have month columns I want to have a new row in month column "ALL" to select all months

[SK28]

I have month columns I want to have a new row in month column "ALL" to select all months

Month:

JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC

i have this column, I need 'ALL' to  be added in the above column so that in when i use that in filter pane it should select 'ALL' months data from JAN to DEC needs to be selected

Month:

JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
ALL

below or how this can be achieved

[ramchalla · Accepted solution]

Hi,

Please check if this helps and find the attached qvw file.

Table1:

LOAD * Inline [

Month,Sales
JAN,10
FEB,20
MAR,20
APR,35
MAY,26
JUN,35
JUL,75
AUG,75
SEP,30
OCT,40
NOV,50
DEC,20

];

Concatenate (Table1)

LOAD 'ALL' as Month,
Sales

Resident Table1;

[Vegar · Accepted solution]

You need to get both the actual month and the 'All' to be associated with your data, preferably without duplicating the data. 

I would consider creating an dimension table associated with "Month" to solve this. 

Transactions:

Load 

Month as %month,

Dim1, Dim2, ..., DimN

From Source;

Months:

Load Month as %month, Month

inline [

Month

JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC];

Concatenate (Months)

Load

%month,

'ALL' AS Month 

Resident Months;

[SK28]

Thank you for the response @Vegar @ramchalla