Hi,

I created a custom group for pivot using a calculated item however I am unable to add more items to it due to its size limitation of 255 chars.

e.g. you wish to group some cities (50 cities) data to Easter-Region group.



Another issue is, Excel is not allowing field which is having calculated item to be moved to Report Filter section.



Any clue is there any alternate way to handle this?