How to add all fields ending with OO in Caluculated Dimention

[#1]

Hi Friends

I have to add lot of fields to a Pivot table which ends with 'OO'.

Can I add all to them to dimentions  at a time using any condition since its long time to identity them from the group of 200 Fields.

Thanks

Pavan

[Gysbert_Wassenaar]

Do you mean fields or values of a field? If you're talking about field values you can try using a calculated dimension instead of the field itself: =if(right(MyField,2)='OO', 'Ends in OO', MyField)

[#3]

HI Gysbert,

I want to add Fields only.

Instead of adding one by one Is there any way to add all the fields which end with 'OO'.

Thanks

[Gysbert_Wassenaar]

Not automatically. You'll have to add them manually.

[#5]

Thanks