Hello. Grouping and summarising data using smart markers have been achieved after i read the article
in which i had to download “Aspose.Cell 5.2.0.5”
but in there i have a slight problem It doesn’t calculate the grand total
when i manually execute (double click in the cell) the formula then it performs the forumla and give me desirable result.
e.g.
CustomerID SaleID
1 Sale-1
1 Sale-2
1 Sale-3
2 Sale-4
2 Sale-5
Now after using smart markers i would like to count total number of invoices against each customer. it should give me
CustomerID SaleID
1 Sale-1
1 Sale-2
1 Sale-3
3
2 Sale-4
2 Sale-5
2
-----------------------------------
Total Invoices 5
My Problem is that i am not getting 5 untill and unless i manually go in the cell and double click and click somewhere else to execute the formula.
Please guide me to rectify this.
Thanks.