Custom Dimension with Sub Totals

So I have create 2 Custom Dimension to group our people with their designated Team and Managers.

First Dimension is for Teams, while 2nd one is Managers.

As I see the score card of our employee I want to see also the Team Score, so by ticking the “Sub totals” do the job (see screenshot). Then I want to see also Managers scores, But after I added the 2nd dimension which is Managers it’s not showing any data.

This is the code for Teams dimension

if (matches_filter(${DA_name},`name1, name2, name3...`), "Team A",

if (matches_filter(${DA_name},`name10, name11, name12...`), "Team B", ...)

This is the code I use for Custom dimension of Managers

if ((${team_name} = "Team A"
  OR ${team_name} = "Team B"
  OR ${team_name} = "Team C"), "Manager A",

if ((${team_name} = "Team D"
  OR ${team_name} = "Team E"
  OR ${team_name} = "Team F", "Manager B", “”))

9bd0502a-5185-400b-b29e-562bac918285.png
0 0 75
0 REPLIES 0
Top Labels in this Space
Top Solution Authors