How to do i group the rows by multiple columns and then calculate Total, Sub Total and then Grand Total. I'm using Smart Marker approach. I'm getting the rows from the database. I have attached two excel files.
The "Sample Data.xslx" shows the incomming data from the database, while the "Expected Result.xslx" shows the exepected output after processing the data. How do i set the Special Markars to get the expected result