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.
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)
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'.
Not automatically. You'll have to add them manually.
Retrieving data ...