How to pivot or group by a measure?

[haileysims]

Hi,

I have a look which, at a basic level, is 1 dimension (user ID) and 1 measure (number of products used). I am looking to group by the number of products used and see the count of users for each. Does anyone know how to do this?

Bonus points for being able to also segment this by another attribute, like geo.

Requirements:

• Must be in Looker UI (no LookML).
• Must allow measure to be dynamic (i.e. I cannot simply have the measure converted to a dimension as the # of products used can change at any time).
• Must be able to be visualized in order to add to a dashboard