Current we have option to add prepend/postpend Text to Line Item in report builder.
By introducing Trim option in Line Item we can get better report.
Example: Pagename has captured as "SG:HomePage:Product1:SubProduct1", i only want to display "SubProduct1" in visualization. Currently we use excel formula to trim these data. Whenever Line Item has increased we need to manually extent these formula, due to these reason unable to automate some reports.
Regards
Ashok