Subtotal Smart Markers Not Working

Aspose.Cells Product Family
1

I’ve got an issue with Smart Markers where I’m trying to subtotal based on multiple criteria. My layout is as follows:

Cell A3 - &=data.CollectorName(group:normal, skip:0)
Cell B3 - &=data.CheckDate(group:normal, skip:0)
Cell C3 - &=data.CheckNumber(group:normal, skip:0)
Cell D3 - &=data.PriorPayment
Cell E3 - &=data.CurrentPayment
Cell D4 - &=subtotal9:data.CheckNumber
Cell E4 - &=subtotal9:data.CheckNumber
Cell D5 - &=subtotal9:data.CheckDate
Cell E5 - &=subtotal9:data.CheckDate
Cell D6 - &=subtotal9:data.CollectorName
Cell E6 - &=subtotal9:data.CollectorName

The result is that cells D4 and E4 do populate appropriately with subtotalled values, but cells D5, E5, D6, and E6 simply print the smart markers and do not subtotal. How do I go about getting this to work where I can subtotal by different groupings?

2

@Ashe,

Thanks for providing some details.

Well, Subtotal rows are dynamic and are inserted dynamically when the markers are processed to fill data. I think you may specify only one subtotal marker (inserted as a separate row, e.g &=subtotal9:TableName.FieldName) while grouping data with respect to grouped column type. Could you try to change your markers as following if it works or not:

Cell A3 - &=data.CollectorName(group:normal, skip:0)
Cell B3 - &=data.CheckDate(group:normal, skip:0)
Cell C3 - &=data.CheckNumber(group:normal, skip:0)
Cell D3 - &=data.PriorPayment(subtotal9:data.CheckNumber)
Cell E3 - &=data.CurrentPayment(subtotal9:data.CheckNumber)
Cell F3 - &=data.PriorPayment(subtotal9:data.CheckDate)
Cell G3 - &=data.CurrentPayment(subtotal9:data.CheckDate)
Cell H3 - &=data.PriorPayment(subtotal9:data.CollectorName)
Cell I3 - &=data.CurrentPayment(subtotal9:data.CollectorName)

I suspect this may not be an issue rather limitation by design of Aspose.Cells’ Smart Markers feature.