Forum Discussion
Column Custom subtotals
Newbie to PowerBI, I'm trying to do a custom subtotal. Is it possible to do a last two columns.
When I enable row level subtotals for Type, it adds points and marks.
When I enable row level subtotals for Sem or Year, it adds points and marks together for both semesters.
| year | 2021 | ||||||
| Sem | Semester-1 | Semester-2 | |||||
| Type | POINTS | MARKS | POINTS | MARKS | POINTS | MARKS | |
| Student1 | |||||||
| MATH | 5 | 90 | 4 | 85 | 9 | 175 | |
| SCIENCE | 6 | 85 | 5 | 80 | 11 | 165 | |
| Student2 | |||||||
| MATH | 4 | 80 | 3 | 75 | 7 | 155 | |
| SCIENCE | 5 | 80 | 4 | 90 | 9 | 170 |
Hi, sathishkeshava
Your sample data looks like this.
Is this the result you expect? If this doesn't resolve your issue, please let us know more.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi, sathishkeshava
Your sample data looks like this.
Is this the result you expect? If this doesn't resolve your issue, please let us know more.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry, I couldn't get back to you earlier. But the data is in below format. Can you produce same layout using below data ? Thanks
