Total in the grid for 2 subject

[Antonio1970]

Product	DB	2025	2026	2027
AB	cycle 2022	100	100	100
	cycle 2023	120	150	120
	cycle 2024	100	100	200
AC	cycle 2022	200	100	100
	cycle 2023	220	150	120
	cycle 2024	200	100	200
AD	cycle 2022	100	100	100
	cycle 2023	120	150	120
	cycle 2024	100	100	200

I would like this Output

Product	DB	2025	2026	2027
AB	cycle 2022	100	100	100
	cycle 2023	120	150	120
	cycle 2024	100	100	200
AC	cycle 2022	200	100	100
	cycle 2023	220	150	120
	cycle 2024	200	100	200
AD	cycle 2022	100	100	100
	cycle 2023	120	150	120
	cycle 2024	100	100	200
Total	cycle 2022	400	300	300
Total	cycle 2023	460	450	360
Total	cycle 2024	400	300	600

[v-aatheeque]

Hi @Antonio1970 

I wanted to check in to see if the suggestions shared earlier by @suparnababu8   helped resolve the issue related to grid for 2 subject.

If you're still facing challenges or have any follow-up questions, please feel free to let us know. We're here to help!

Looking forward to your update!!

Thank you for being an active member of the Microsoft Fabric Community!

[v-aatheeque]

Hi  @Antonio1970 

I wanted to follow up and see if the suggestions provided earlier by @suparnababu8   helped resolve the issue related to the grid for the two subjects.If you're still encountering any difficulties or have any additional questions, please don't hesitate to reach out. We're here to assist you!

I look forward to hearing from you soon!

Thank you for being an engaged member of the Microsoft Fabric Community!

[v-aatheeque]

Hi @Antonio1970 

I wanted to follow up regarding the suggestions provided earlier by @suparnababu8   concerning the grid issue for the two subjects.Have those recommendations helped in resolving the problem? If you are still encountering any difficulties or have additional questions, please don’t hesitate to reach out. We’re here to assist you!

I look forward to hearing from you soon!

If we don’t hear back, we may close this thread in line with our community guidelines, but you’re always welcome to post a new query anytime.

Thank you for being part of the Microsoft Fabric Community!

Thank you for your active participation in the Microsoft Fabric Community!

[suparnababu8 · Accepted solution]

Hi @Antonio1970 

If you are looking for the below output..

You can download pbix file and explore it.

Hope this works for you.

Thank you!!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!