Add one single column to straight table

[bartvanwetten]

Dear all,

how can I add one single column at the end of the straight table in the attached document?

Thx for your help!

Bart

[datanibbler]

Hi Bart,

why, to add a column, just add a formula.

HTH

[MK_QSL]

Try to add one more Expression!

[Colin-Albert]

Add the expression or dimension you need, then you can drag the column to the required position by clicking & dragging on the column header.

Allow Drag and Drop must be enabled on the Presentation Properties of the chart. This is usually enabled by default.

[pokassov · Accepted solution]

Hi all.

This question is not so simple, like looks.

Bart used horisontal straight table.

So he doesn't need 2 expression. He needs 2 dimenstions.

Bart, can you add one field in your model something like this

fieldlevel

1

2

then you have to add this field to table and hide it. Also you have to change your first dimention

dimention:

=if(fieldlevel=1,replace($(vPeriodeSelectie),'2014','2015'),'total')

[bartvanwetten]

Hi CepreN (sorry for the bad syntax spelling your name),

many thx for your reply, works perfect. Now I know how to manipulate straights, tailormade totals , in the future.

Kind regards,

Bart