To get Total in between categories.
Hi, I have a table like this in Sheet 1- And from the sheet 1, I want to create Page 2 in Power BI which is like in Sheet 2 below- Difference is here the Total is populated through Sum formula. Values have been achieved through Vlookup- How I can do the same in Power BI by Exporting Sheet 1 and creating Sheet 2 from Sheet 1. Thanks, Amit Kumar
