 Rank: Member
Groups: extranet\Forum
Joined: 11/4/2019(UTC)
Posts: 9
|
While using a cross tab , I would like to insert column names for few fields. I have attached image please refer and support.I tried doing but option not available. https://ibb.co/Jd5RWxyIf you notice above image url, i have a red box with names i have to add for the column header.but couldn't do it. Please help me out. I am using cross tab with dimension, measure and title for the columns.When the title column is added this problem occurs but i need an o/p showed in the image
|
|
|
|
|
|
 Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 508
|
Hi Annie,
You might try this work-around:
Go to Calculations and add a new Custom calculation, As a new measure. Just leave the syntax as it is: 0.
Already at this point you should see column headers for the dimensions on your vertical axis.
Go to Properties / Visibility to hide the newly added calculation.
If you need to change any of the column headers (for the measure or any of dimensions), right click the column header and go to Table / Dynamic captions / Edit for all members on this level. In the Smartpad on the left you can now replace {cellvalue} with whatever text you would like to see in your column header.
BR / Ole |
Ole Dyring |
|
|
|
|
|
Rank: Member
Groups: extranet\Forum
Joined: 11/4/2019(UTC)
Posts: 9
|
Thank You So Much ! It works ...Hurrah !! Originally Posted by: Ole  Hi Annie,
You might try this work-around:
Go to Calculations and add a new Custom calculation, As a new measure. Just leave the syntax as it is: 0.
Already at this point you should see column headers for the dimensions on your vertical axis.
Go to Properties / Visibility to hide the newly added calculation.
If you need to change any of the column headers (for the measure or any of dimensions), right click the column header and go to Table / Dynamic captions / Edit for all members on this level. In the Smartpad on the left you can now replace {cellvalue} with whatever text you would like to see in your column header.
BR / Ole
|
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.