Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Pivot table: Concatenate two Measures (Sums) into a string with separator(Pivot table: Concatenate two Measures (Sums) into a string with a separator)
Pivot table: Concatenate two Measures (Sums) into a string with separator [message #1803481] Fri, 01 March 2019 11:45
Man Sari is currently offline Man SariFriend
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
Previous Topic:Inset line break in dynamic, grouped, data?
Next Topic:Graph aggregate Data
Goto Forum:
  


Current Time: Tue Mar 19 07:47:43 GMT 2024

Powered by FUDForum. Page generated in 0.02621 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top