The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
We have a matrix that has 2 columns (Amount and Quanity) and the matrix is broken up by Year. So the matrix would look like this
Amount/Quantity - Amount/Quantity - Amount/Quantity (with headers above 2005, 2006 and 2007)
Question: Is it possible to subtotal/total to the right for just one column (i.e. Amount). Right now if you turn the sub-total/total on, it will add all values across the grid. Can we separate these?
This is what we would like to have
Thanks,
Aaron
Solved! Go to Solution.
@AaronToth There is a way but it is not exactly pretty. You can shrink the unwanted columns or you can do this:
@AaronToth There is a way but it is not exactly pretty. You can shrink the unwanted columns or you can do this:
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |