3 Replies Latest reply: Dec 7, 2014 6:59 AM by Демо Демо

# Field value in Set Analisys

Hi!

I have a list of Accounts and need to calculate expression, based on conditions. Conditions for each Account are different.

Example:

Table1:

AccountCondition
Account1'Dim1'
Account2'Dim2'
Account3'Dim1','Dim2'
Account4'Dim2',''Dim3'

Table2:

DimValue
Dim110
Dim220
Dim330

Condition is a set of Dims.

Accounts is Dimension in PivotTable.

I'm writing such Expression:

Sum({<Dim = {\$(=Condition)}>}Value)

It doesn't work.

I tryed to use advice from this post Re: How to add Different Expressions for Different rows of a table ???

I'm making a variable Exp = "Dim1", "Dim2","Dim1,Dim2", "Dim2,Dim3", a field row = RowNo() and writing such expression:

Sum({<Dim = {\$(=Pick(row, \$(Exp)))}>}Value).

It works, only if I'm changing row to a specific value (1 or 2).

So field row is not divided on dimension.

If you have any ideas, help please.

Thank you!

• ###### Re: Field value in Set Analisys

Table1:

Account, Condition

Account1, "Dim1"

Account2 ,"Dim2"

Account3 ,"Dim1,Dim2"

Account4 ,"Dim2,Dim3"

];

Table2:

Dim, Value

Dim1, 10

Dim2 ,20

Dim3, 30

];