Count number of visit

building reports desktopintelligence
1

I am try to count how many visit paid by customer considering as visit a purchase on a date
I would like to obtain

Visit Customer
1 200
2 33
3 5
7 1

so in the example I have only one customer that have purchase in 7 different dates.

The only way I have found to obtain similar result is using a different formula in each column like

=Sum(Count([GL Date]) In ([Customer Number]) =1)
=Sum(Count([GL Date]) In ([Customer Number]) =2)
=Sum(Count([GL Date]) In ([Customer Number]) =3)
etc.

Any suggestion to obtain the above is a cleaner way?

fabdav (BOB member since 2012-02-17)

2

What’s your starting data items and what do you want as your result?