|Pivot table: Concatenate two Measures (Sums) into a string with separator [message #1803481]
||Fri, 01 March 2019 11:45
| Man Sari
Registered: March 2019
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.
m1 m2 m1 m2
d21 m12111 m22111 m12112 m22112
d22 m12211 m22211 m12212 m22212
m1 / m2 m1 / m2
d21 m12111 / m22111 m12112 / m22112
d22 m12211 /m22211 m12212 / m22212
Is it possible ?
Thank you for your answers!
Powered by FUDForum
. Page generated in 0.01690 seconds