Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi, This Sub Total is not useful for me. I need to show subtotal of B and R values before GrandTotal in like Excel view which i created manually. Can you please help me do it?
Hi @aslan,
You can turn on the row total, it will auto calculate the total amount of each level of row field.
You can find it at: Format -> general -> Total row option.
Regards,
Xiaoxin Sheng
| User | Count |
|---|---|
| 44 | |
| 35 | |
| 30 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 65 | |
| 57 | |
| 40 | |
| 21 | |
| 20 |