Merging Same Text/Value Dimension in table

[Gabbar]

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.

[Rohan]

Hi @Gabbar ,

Pivot is the only option for your case.

Regards,

Rohan.

[Gabbar]

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.

[Rohan]

Hi,

In the Appearance Tab, switch to fully expanded option : 

Regards,

Rohan.

[Anil_Babu_Samineni]

Please try to remove null values for first dimension. 

[Gabbar]

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.

[Gabbar]

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.

[Rohan · Accepted solution]

Hi @Gabbar ,

Have you unticked the Indent rows option ?

Regards,

Rohan.

[Gabbar]

Thanks, This is what I need.