Cross Pivot Renaming and Displaying in Email Body

[bigbang]

Hello,

I have a dataset where the columns are as follows:

Id	Category	Ageing Bucket
A1	Type1	0-5
A2	Type2	5-10
A3	Type2	11-20
A4	Type1	5-10

I need to create a pivot table with

Row-> Category

Column -> Ageing Bucket

Value -> Count of Ids

Problem facing here using Cross tab: The column is renaming to Count_5_10 , Count_11_20. I want this to be renamed to the original values 5-10,11-20 and so on

After renaming this, I need this pivot to be part of email body. 

Any help is appreciated.

[binuacs · Accepted solution]

@bigbang use the dynamic rename tool to rename your column headings

Replace(Replace([_CurrentField_],'Count_',''),'_','-')