How to Use CountDistinct
Posted: Tue Oct 28, 2014 7:18 am
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.
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.