Create 2 measures from single dimension

[Guest_imported]

Hi all,

My data looks something like

Code1 Acc Team
----- --- ----
AC 1234 K10
AB 4434 K10
AB 3333 K10
........

What I am trying to get is

Team Approved Active
K10 3 2

If Substr(<Code1>,1,1) = A it means it is approved
If Substr(<Code2>,2,1) = B it means it is active..

I can't get the Approved and Active together using filters... I tried coming up with measures # Approved and # Active but it doesn;t seem to work... anyone with a solution?? Thanks

John

 

[promero]

¿Solves this your problem?

<Approved> = Sum((Substr(<Code1>,1,1)=&quot;A&quot ForEach (<Team>, <Code1>, <Acc>))

<Active> = Sum((Substr(<Code1>,2,1)=&quot;B&quot ForEach (<Team>, <Code1>, <Acc>))