Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
Hi Bart,
why, to add a column, just add a formula.
HTH
Try to add one more Expression!
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.
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')
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