Merge two columns

[souadouert]

Good Morning

How to merge two columns with pivot table

[sunny_talwar]

This is what I did

Script

Table:

LOAD * INLINE [

    Rubriques, Effort brut, relisCumule2017, Objectif2017, Zone, Region

    Conquete client, 10, 20, 52, 12, 10

];

Dim2:

LOAD * Inline [

Dim2

1

2

3

4

5

];

So, basically add Dim2 as an inline table in your script

and then this

Dimensions

Rubriques

=Pick(Dim2, ' ', ' ', ' ', 'TRRP', 'TRRP')

=Pick(Dim2, 'Effort brut', 'relisCumule2017', 'Objectif2017', 'Zone', 'Region')

Expression

Pick(Dim2, Sum([Effort brut]), Sum(relisCumule2017), Sum(Objectif2017), Sum(Objectif2017), Sum(Region))

[souadouert]

thank y sunny

[murugesh]

I could not able to view your Merge two columns expression could you send me it

[murugesh]

I could not able to view your Merge two columns expression could you send me it

[nahlaalami]

hey , 

Please  i didn't understand !!

you have create a new dimension in your script , but what's is 1,2,3,4,5 refers to?.