use a matrix to create the below view and then drill down horizontally for each group

[Rambo_1]

Hi,

I want to use a matrix to create the below view and then drill down horizontally for each group, see below:

Table
Category - Chairs Tables Desks Pants T-shirts Jerseys
COUNT    - 1        2          3        4        5           6

Want to group by columns like this
CategoryGroupBy   Furniture     Clothing
SUM                       6                   15

But then be able to drill down on either furniture or clothing
CategoryGroupBy    Furniture                  Clothing
Category                  Chairs Tables Desks Pants T-shirts Jerseys
                                 1         2         3         4        5           6

Thanks you

[Rambo_1]

I have used grouping for my categories, is it possible to drill across on those groups like below:

CategoryGroupBy	Furniture
		Chairs	Tables	Desks
		1	2	3
CategoryGroupBy	Clothing
		Pants	T-shirts	Jerseys
		4	5	6

[V-lianl-msft]

Unfortunately,Only these two types of drilling are supported for the time being.

[V-lianl-msft]

If there is no group column in the table, you can use M query to create it in the query editor.