Pivot: Count Distinct

[ctrl-alt-d]

Hi,

I would like to create a Pivot table with a Distinct Count data field. I guess that this is not supported at this time. Can you confirm?

In Excel, to do a Distinct Count, it is mandatory to create pivot checking "Add this data to the Data Model" also change "Summarize Values By".

Congrats about this library, it is awesome. Best regards.

[JanKallman]

No, data models are currently not supported, so the Distinct Count will not work with EPPlus. I'll add this as an enhancement for now.