Help with formula

[#1]

I'm trying to write a formula that will give me the following detail for each of the two columns Svc Group and Svc line.

I only want to pull in the following from Svc Group:

MC

RC

TR

And I only want to pull in the following from Svc Line:

Transaction

FRM

RC Other

Technology Enablement

Can anyone please help

[sunny_talwar · Accepted solution]

May be try this expression:

Count({<[Svc Group] = {'MC', 'RC', 'TR'}, [Svc Line] = {'Transaction', 'FRM', 'RC Other', 'Technology Enablement'}>}[Partner ID])

[sunny_talwar]

Or this, if this is not and condition, but an or condition (show this or show that)

Count({<[Svc Group] = {'MC', 'RC', 'TR'}>+<[Svc Line] = {'Transaction', 'FRM', 'RC Other', 'Technology Enablement'}>}[Partner ID])

[Chanty4u]

load *,

........

from table

Where  svcgroup='mc','rc','tr'   and  Svcline='

'Transaction',

'FRM',

'RC Other',

'Technology Enablement';

[#5]

If I were to go this route I would do this in the edit script correct?

Would this limit svc group and svc line to only those that I've selected throughout the file.  So any graphs or charts that I use it will only display svcgroup='mc','rc','tr'   and  Svcline='

'Transaction',

'FRM',

'RC Other',

'Technology Enablement';

[#6]

sunindia I notice that after Count you have {< and at the end of your formula you have >}.  Why do you have these in there?

[sunny_talwar]

This is a set analysis syntax. For more information on set analysis, it would be good to spend some time on the attached document