Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
Not automatically. You'll have to add them manually.
Thanks