Crosstable problem

[michael_maeuser]

Hi, I have a calculation with the dimension Product. Then I have a calculation scheme with about 10 steps. Per step I calculate an acutal and a budget value.  I want it to look like the attached table. On the left side of the table i see the expression names. e.g. unit price. so if i add now an budget unit price, i will have another line. but i want it in the same line. just in another column. does anyone know how to do that?

Thanks in advance!

Michael

[#2]

can you provide sample application with dummy data.

[lironbaram]

you can create a filed with the vlaues : Actual and budget

then use it as a dimension and in the expressions use an if statement

[michael_maeuser]

attached is sample date. there are now 2 lines in the tabe with raw mat act. und raw mat budget. i would like to have one line Raw Material and then two columns (actual and budget). Thanks for helping!

@liron: I also thought of an field but this is not working very well

[lironbaram]

check this one

[michael_maeuser]

Yeah, but i have maybe like 10 steps in the calculation.

so next one is packaging material. and if now add the expression these costs it will be in a third column. but it´s supposed to be in the line below. do you know what i mean?

[#7]

Hi Michael,

you can use ValueList('Name Of expression1','Name Of expression2','Name Of expression3') in Dimension (as  calculated Dimension) and in Expression u need to write

If( ValueList('Name Of expression1','Name Of expression2','Name Of expression3')='Name Of expression1', Epression1,Expression2) .

I hope this will solve ur purpose..

[lironbaram · Accepted solution]

check this one

[#9]

Hi Michael,

you can use ValueList('Name Of expression1','Name Of expression2','Name Of expression3') in Dimension (as  calculated Dimension) and in Expression u need to write

If( ValueList('Name Of expression1','Name Of expression2','Name Of expression3')='Name Of expression1', Epression1,Expression2) .

I hope this will solve ur purpose..

[michael_maeuser]

perfect thank you!!!