List of values with set analysis

[#1]

Hi everyone,

I am a little bit stucked in here. please help me out.

I need to get a list of values (society) which are filtered over multiple criterias.I can't do it with set analysis as it requires an aggregate.

I was only able to sum number of contract like this

Sum({$<[Type]={'Contract'},[Brand]={'xxx'},[Product]={'test'},[end of contract]={$(=$(vYesterday))}>} [contract counter])

Based on this set analysis I would need the list of customers which match.

Thanks

[sushil353]

Hi,

Try to use only() to get the list of values.

HTH

sushil

[its_anandrjs]

Write like

=Sum({$<[Type]={'Contract'}, [Brand]={'xxx'}, [Product]={'test'}, [end of contract] = {'$(=$(vYesterday))'} >} [contract counter])

[#4]

hi,

It doesn't work.

I want to display the values in a text box or a in list.

[#5]

no,

my formula is working for sum purpose. All I need is to get the list of associated values based on the criteria.

[arjunkrishnan]

Sum({<FieldName={'FieldValue'}>}MeasureFieldName)

eg:

Sum({<A={'Society'}>}contract counter)

[tresesco]

If you want the list in a text box separated by a delimeter, you can try with concat(), like:

Concat({$<[Type]={'Contract'},[Brand]={'xxx'},[Product]={'test'},[end of contract]={$(=$(vYesterday))}>} Distinct Society, ',')

[sushil353]

try this:

Only({$<[Type]={'Contract'},[Brand]={'xxx'},[Product]={'test'},[end of contract]={'$(vYesterday)'}>} [contract counter])

HTH

Sushil

[#9]

ok thanks. IT works. What if I want now to use this list to filter a straight table ?

[tresesco]

Say you want these Society values to be there in the dimension of straight table and an expression like: Sum(Amt). In such scenario, if you take Society as dimension and imply the same set anaysis with sum() like you have shown above, your dimension Society gets filtered for those values only.