Page 1 of 1

How to Use CountDistinct

Posted: Tue Oct 28, 2014 7:18 am
by 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.

Re: How to Use CountDistinct

Posted: Tue Oct 28, 2014 12:08 pm
by HighAley
Hello.

Please, set the Summary property to CountDistinct.
CrossTabSummary.png
CrossTabSummary.png (51.38 KiB) Viewed 2308 times
Thank you.

Re: How to Use CountDistinct

Posted: Wed Oct 29, 2014 2:07 am
by Andy1120
OK,it is great.I try it.Thank you.

Re: How to Use CountDistinct

Posted: Wed Oct 29, 2014 2:16 am
by Andy1120
thanks.it is OK.

Re: How to Use CountDistinct

Posted: Wed Oct 29, 2014 7:47 am
by HighAley
Hello.

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

Thank you.