Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Formatting Grand Total Column in cross tab
Migrateduser
<p>I have attached an example of cross tab in which i have formatted the 'credit value' in below format : </p>
<p>"£"+data["CREDITLIMIT_Group/COUNTRY_Group1/CUSTOMERNAME"]+"mill"</p>
<p> </p>
<p>I have created a derived expression to set the above format. But now I want the same format to be displayed in grand total column as well. But I didn't find to add an option of ' add derived measure'.</p>
<p> </p>
<p> </p>
<p>Can we format the grand total column to have suffix and prefix value ? eg: ("£"+ Credit Value Column + "mill")</p>
<p> </p>
<p> </p>
Find more posts tagged with
Comments
There are no comments yet