Merge two columns

[souadouert]

Good Morning

How to merge two columns with pivot table

[sarvesh]

As i understand you don't want to change the column name..right ?

[souadouert]

I want to view the two columns zone and region under a header named trpp

[sarvesh]

For this you have to add row.

[souadouert]

y mean  calculated dimension ?

[sarvesh]

if you want headers "zone and region" under header "trpp" then yes, however if you want only values of "zone and region" under header "trpp" then write the syntax:

zone & ', ' & region as trpp

[sunny_talwar]

and what about the rest of the three columns?

[souadouert]

I apologize I do not understand anything i have not the ability to use AS in expression of calculated dimension, and zone ans region are two label for two expression

region: ([Effort brut]/[Objectif 2017])/MONTHNUM

zone:([Effort brut]/round(sum({< REGION,REGION = {$(=(REGION))}>}[OBJ_CONQUETE.TOTAL])/100*60))/MONTHNUM

[sarvesh]

Now i'm confused ha ha ha

Could you share desired format of the table, if you can draw manually.

[souadouert]

[sunny_talwar · Accepted solution]

Like this?