Count

Question

Hi,&nbsp;I have a table that output like this&nbsp;&nbsp;Brand.&nbsp; CustARC.&nbsp; &nbsp;10BT.&nbsp; &nbsp; &nbsp; 10Mc.&nbsp; &nbsp; &nbsp;10RY.&nbsp; &nbsp; &nbsp; &nbsp;8WHS.&nbsp; &nbsp;6However, I'd like to see the matrix look like this where by "cust" becomes a Column and the Volume underneath is the sum of the "brand".&nbsp;10.&nbsp; &nbsp; &nbsp;8.&nbsp; &nbsp; 63.&nbsp; &nbsp; &nbsp; &nbsp;1.&nbsp; &nbsp; 1&nbsp;Is this possible please?&nbsp;&nbsp;&nbsp;

ritaf1983 · Accepted Answer

Hi&nbsp;M_SBS_6&nbsp;You can use a matrix visual with cust on rows and counting the brands on values.

pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
&nbsp;

Forum Discussion

Count

2 Replies

Related content

Counting nulls

Count Of Drivers

Count Measure

count distinct

Counting Non-Blank Records