I’m new to Looker and this question could be a silly one. Appreciate all the inputs I receive.
I have 3 dimensions State, City and Product and a measure number of Sales. In my table visualization, I want to see City, as child of State, and pivoted to give me the number of Sales across different products. Below visualization could give a better idea of wht I have in mind.
This sort of grouping could be done in Tableau so wondering how to do this in Looker.
Any ways I could achieve this? Thanks.