How to take only some values from created dimentions table

[#1]

Hi  Friends,

I have created a Dimentions table while loading tables.

Dimentions:

Commisions

Premiums;

Now I want to add only one of these dimentions into pivot table.

When add Dimentions its taking both Commisions and Premiums into the table Dimentions

Thanks

pavan

[walterlh]

Utiliza IF()

[tresesco]

Try calculated dimension. Expression like: =if(Dimension='Commisions', Dimension) , then in the same tab check 'Supress Values When Null'.

[walterlh]

Como se llama tu campo? donde guardas "Comisiones y Las primas"...

[mohamed_ahid]

i didn't get you . can you send us an exemple or may be an app?