Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have something similar to the following table:
Act# Desc Budget Actual
100 Operations 1000 800
105 Admin 900 700
200 Chicago 1000 500
205 St. Louis 1000 400
210 Des Moines 1000 350
215 Detroit 1200 400
220 Columbus 1000 250
225 Indianapolis 800 600
230 Toronto 900 800
245 Monterrey 1200 900
300 Kingston 1000 750
I would like to be able to have something like the following:
Act# Desc Budget Actual
100 Operations 1000 800
105 Admin 900 700
Operations Subtotal: 1900 1500
200 Chicago 1000 500
205 St. Louis 1000 400
210 Des Moines 1000 350
215 Detroit 1200 400
220 Columbus 1000 250
225 Indianapolis 800 600
Midwest Subtotal: 6000 2500
230 Toronto 900 800
245 Monterrey 1200 900
300 Kingston 1000 750
International Subtotal: 3100 2450
Grand Total: 11000 6450
How would one combine the account numbers/descriptions to the appropriate groups and get the totals of each group? Appreciate the time and help.
Create a new column in your data called "Grouping" or something similar. Place into this column, on a row by row basis, which group each row belows. If you already have this data, you can make use of it.
Once you have this additional column, you can use this column in your "Rows" data. The matrix and table visuals will have a subtotal switch you can turn on.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |