Welcome to the Blazor feedback portal. We’re happy you’re here! If you have feedback on how to improve the Blazor, we’d love to hear it!>
Thanks for joining our community and helping improve Syncfusion products!
In general, only the records count will be considered as an aggregation when binding string fields to the pivot table's value axis. This means that for string type fields, Count and DistinctCount will be considered. Binding string fields with DistinctCount aggregation type, on the other hand, does not currently support in pivot table, and it always considers only one record count instead of calculating unique records. As a result, the DistinctCount aggregation type must be provided when binding string fields as values. Please see the screenshot below.
