How to add new field values to existing Dimension

[MMARG83]

Dear All.

I need to add two new field items to an  existing dimension. And  apply expressions on those new field items to display results in a pivot table.

• Table = TAB1 SUM({<DESCRIPTION={'GRATUITY A/C'}[DR AMT])/12*100
• Dimension=DESCRIPTION
• New items= STAFF SALARY & CASUAL WAGE  

Expressions

STAFF SALARY.

SUM({<DESCRIPTION={'GRATUITY A/C'}[DR AMT])/12*100

CASUAL WAGE.

SUM({<DESCRIPTION={'EPF 12%'}[DR AMT])/12*100

is this possible,

Can some one help me ...Please........

[Chanty4u]

you can do in script something like below

Concatenate (TAB1)

LOAD

DISTINCT DESCRIPTION,

'STAFF SALARY' as DESCRIPTION

AUTOGENERATE 1;

Concatenate (TAB1)

LOAD DISTINCT DESCRIPTION,

'CASUAL WAGE' as DESCRIPTION

AUTOGENERATE 1;

[MMARG83]

Dear Chanty4u.

Thanks.. need to add square brackets to get the field values to show under the dimension,

• Concatenate (TAB1)
• LOAD [
• DISTINCT DESCRIPTION,
• 'STAFF SALARY' as DESCRIPTION
• AUTOGENERATE 1];
• Concatenate (TAB1)
• LOAD [DISTINCT DESCRIPTION,
• 'CASUAL WAGE' as DESCRIPTION
• AUTOGENERATE 1];

but how do i add expressions to theses field values.