- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Merging Same Text/Value Dimension in table
Hello, Currently My table looks Like
as you can notice the first column has values that are repeated. Like same value twice and same is of second and third column.
While I want to change my table to look like
Like merge and centre of excel.
Is there any way to do this or any custom object that helps to do this.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Pivot then shows null values in straight line like
and This is also after I have made first 3 column as key.
So if there is any customisation please help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
In the Appearance Tab, switch to fully expanded option :
Regards,
Rohan.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please try to remove null values for first dimension.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The Screen Shot i shared is after selecting Fully Expanded rows. As my measure depends on the type of dimension i.e (Customer Matrix and Customer Forecast) it will show null values in Main Dimension rows.
To solve I Concatenated 3 dimension by using '&' to form one dimension but i still get one row of abnormal Values.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Those are not null values, Those are abnormal values. The measure i use Depends on Type(Customer Matrix and Customer Forecast) Dimension. Thus in first row for the dimensions without having Dimension Type it cannot show any value.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks, This is what I need.