How to Use CountDistinct

[Andy1120]

Hi
I have a Cross table which likes below
data:
billno provider amount date
A0001 001 5000 2014-09-15
A0002 001 600 2014-09-16
A0003 002 1000 2014-10-01
Cross Table:
proviver date
2014-09 2014-10 Total
billcount amount billcount amount billcount amount
001 2 6500 2 6500
002 1 1000 1 1000

I use the CountDistinct(date) in the processcell that can't get value.
I use the CountDistinct(date) in the show value that get error.
How can I do?
Bestwishes
Thank you.

[HighAley]

Hello.

Please, set the Summary property to CountDistinct.

CrossTabSummary.png (51.38 KiB) Viewed 2304 times

Thank you.

[Andy1120]

OK,it is great.I try it.Thank you.

[Andy1120]

thanks.it is OK.

[HighAley]

Hello.

We are always glad to help you.
Let us know if you need any additional help.

Thank you.