Hide Data?

[Rylan Demers]

Hello!

I am new to Google Looker. 

We are looking to use it as our Enrollment Dashboard. Currently, I have a pivot chart with Grade and Homeroom and the # of students in each homeroom as the metric.

Grade - HR \ # std

1 - Teacher A - 12

1 - Teacher B - 20

2 - Teacher A - 15

I really don't want to show the name of the homeroom but still "show" the students in each one.

Grade - HR \ # std

1 -  12

1 - 20

2 - 15

Any ideas? 

Thanks,

Rylan

 

[BONNIE HICKS]

Not really sure what your original source is but, based on the above, you could create a calculated field with something like: 

 CONCAT(LEFT_TEXT(fieldname,3),RIGHT_TEXT(fieldsname,3))