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

 

[blom0344]

Hello John,

Try this

Create variables:

FirstPos =Substr(<Code>,1,1)
SecondPos =Substr(<Code>,2,1)

CountApproved = Count(<Team>) in <Code> (where FirstPos = A)
CountActive = Count(<Team>) in <Code> (where SecondPos = B)

Use these in a table , hide the column with Code. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com