We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Group data in multiple levels in MS Excel worksheet using Smart Markers

Hi Team,

We have a dot net application to generate reports.

We are using Smart Markers for the same.

I need to create a report with three levels of grouping. the group is working fine. but I an not able to show the subtotals for them.

Example:
mumbai, malad, east, 10
mumbai, malad, east, 20
mumbai, malad, east, 5
Total east 35
mumbai, malad, West, 10
mumbai, malad, West, 20
Total west 30
Total malad 65
mumbai, boriwali, east, 5
Total east 5
mumbai, boriwali, West, 5
Total West 5
Total boriwali 10
Total mumbai 75

Hi,

Thanks for your posting and considering Aspose.Cells.

Please manually create your sample excel file with two sheets. The first sheet should contain your sample data and the other sheet should contain your expected output data which you want to generate using Smart Markers. You can create both of these sheets using Microsoft Excel and attach it here. It will help us investigate this issue more closely and precisely and we will let you know if such a feature is available or if there is some workaround for it. Thanks for your cooperation.