Change Dimension Label

[swati_rastogi27]

I have a column CURR_CD which displays Currency codes like EUR,GBP etc.

All my calculations like 'Total No. of Invoices booked' , 'Total Value of Invoices booked' etc are grouped by Currency.

In my straight table I will use CURR_CD as my dimension , but I want to display the dimension text as No. of Invoices booked in EUR etc.

For depiction purpose , I will show the data in excel format:

Current output is :

Required output is:

[sunny_talwar]

Maye be change your dimension to a calculated dimension:

='No of Invoices booked in ' & CURR_CD

[pooja_sn]

Add a calculated dimension as

'No of Invoices booked in ' & CURR_CD