Pivot table: Concatenate two Measures (Sums) into a string with separator [message #1803481] |
Fri, 01 March 2019 11:45 |
Man Sari Messages: 1 Registered: March 2019 |
Junior Member |
|
|
Hello,
I rather searched before asking my question here.
I have a very simple Data Cubes, with two Dimensions and two Measures.
I have one dimension (d1) on the abscissa and the other one (d2) on the ordinate.
I put my Measures (m1 and m2, which are sums) in two columns (two cells). It works very well of course.
I would like to display, instead of the two columns (and two cells) of measures, a single column (and thus a single cell), which contains the measure m1, a separator ("/"), and the measure m2.
Current :
d11 d12
m1 m2 m1 m2
d21 m12111 m22111 m12112 m22112
d22 m12211 m22211 m12212 m22212
Needed :
d11 d12
m1 / m2 m1 / m2
d21 m12111 / m22111 m12112 / m22112
d22 m12211 /m22211 m12212 / m22212
Is it possible ?
Thank you for your answers!
Best regards,
Man
|
|
|
Powered by
FUDForum. Page generated in 0.02621 seconds