Add calculated dimension

[stekol61]

Hi!

I have created a simple table and added a measure with this calculation:

If (wor_AssignmentProfile ='Eltel - FS - SE - B2B' and wor_AssignmentProfile ='Ericsson - FS - SE - B2B',Sum([Eltel SWE])-Sum([Transtema]))

If I include the dimension (wor_AssignmentProfile ) in the table the result is OK.

Excluding the dimension in the table the result is not OK.

I don't want to use the dimension in the table. Can this be handled in the calculation or in some other way?

[hopkinsc]

Can you not hide the dimension in the presentation tab? or do you not want it there at all?

[agigliotti]

how is your table (dimensions and measures) and what is your actual and desired output?

[stekol61]

Hi!

My table look like the enclosed picture.

The expression in my example is for the 'Cost' measure.

The dimension used is 'wor_AssignmentProfile'

Using the dimension in the table the calculation for 'Cost' is OK. Without the dimension the calculation is not OK.

I don't want to use the dimension in the table but i want the calculation for 'Cost' to be correct

[agigliotti]

how does the measure "Cost" looks like?

[stekol61]

Like this

f (wor_AssignmentProfile ='Eltel - FS - SE - B2B' and wor_AssignmentProfile ='Ericsson - FS - SE - B2B',Sum([Eltel SWE])-Sum([Transtema]))

[agigliotti]

let's try with the below expression:
sum( Aggr( if (wor_AssignmentProfile ='Eltel - FS - SE - B2B' and wor_AssignmentProfile ='Ericsson - FS - SE - B2B',Sum([Eltel SWE])-Sum([Transtema])), Dim, wor_AssignmentProfile ) )

[stekol61]

Hi!

It doesn't work.

If I select both 'Eltel - FS - SE - B2B'  and'Ericsson - FS - SE - B2B' the Cost will be '0'.

Even if I select just one them the result is *0*

[albert_guito]

Hi,

It seems an intersection of set analysis.

Try with this:

Sum({<wor_AssignmentProfile ={'Eltel - FS - SE - B2B'}>+<wor_AssignmentProfile ={'Ericsson - FS - SE - B2B'}>} (Eltel SWE]-[Transtema])

Albert

[stekol61]

Hi!

This expression doesn't work at all.

I receive *Error in expression' when I try to add it to the table.