If function

[iliaisyah]

i wish to add calculated dimension in pivot table to show only system called 'MPC' and MAIC

here is my calculated dimension 

=if([system] = 'MPC' or [system]='MAIC',[system])

but error in expression

if i want to display only MPC

=if([system] = 'MPC',[system])

it works but the table shows MPC and -

how i want to make the table only MPC and MTG only

here is the excel. apology as i cannot open anymore qvw file as im using free edition

[MindaugasBacius]

You need to change expression instead of adding calculated dimensions.
Use set analysis to achieve your goal like:
Count({<system = {'MPC', 'MAIC'}>} Field)

[iliaisyah]

the equation is still error in expression

[iliaisyah]

plus, the expression will have 12 expression as the value is from Jan to Dec (01-12)

[sunny_talwar]

I don't see why this would error out

=If([system] = 'MPC' or [system] = 'MAIC', [system])

But may be try this as an alternative

If(Match(system, 'MPC', 'MAIC'), system)