4 Replies Latest reply on Aug 17, 2018 6:04 AM by Naveen B

# Multiple Measures with Dynamic Column Header

Hello Everyone,

I really need your help on this. I have tried all sort of things and it just wont work.

As you can see the first Measure "LIQ-BAL" shows the amount for 2 different months in 2 different columns. Now the problem is that i want the 3 column gone. The 2nd measure should only be displayed on 1 column and not 2. Is there any way i could display the 3 columns only. The 3 columns should display 31. Mai 2018, 29. Juni 2018 and abs. Is there anyway to make column header based on measures dynamic?

Thank you

Kont

• ###### 1. Re: Multiple Measures with Dynamic Column Header

HI Thomas,

If i am right abs is difference between 29 June 2018 to 31 Mar 2018

Create a calculated field like below

Calculation:

ZN(SUM(if {MAX([Order Date])}=[Order Date]then [Sales]END))

-

ZN(SUM(if {MIN([Order Date])}=[Order Date]then [Sales]END))

Enable the row grand totals

Now create a calculated field like below

Place it in text  your final view will be like below

you can find the differences

hope this helps find the attached workbook

Kindly mark this answer as correct or helpful so that it will help others

BR,

NB

• ###### 2. Re: Multiple Measures with Dynamic Column Header

Hallo Naveen,

well done. that's exactly what i was looking for. 1 more question though. Is it possible to add another column behind the abs "in %". I would want the % change as well behind the abs column.

Is this possible?

Besides that, can the "abs" and "in %" column be applied with conditional coloring? If positiv green and if negative red for the font.

Thank you

Regards

Thomas

• ###### 3. Re: Multiple Measures with Dynamic Column Header

We cant add the column next to abs but you can add the value in bracket

Besides that, can the "abs" and "in %" column be applied with conditional coloring? If positiv green and if negative red for the font.

Yes you can do it like below you will get the view

BR,

NB

• ###### 4. Re: Multiple Measures with Dynamic Column Header

Attachment

BR,

NB