Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |