Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning
How to merge two columns with pivot table
As i understand you don't want to change the column name..right ?
I want to view the two columns zone and region under a header named trpp
For this you have to add row.
y mean calculated dimension ?
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
and what about the rest of the three columns?
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
Now i'm confused ha ha ha
Could you share desired format of the table, if you can draw manually.
Like this?