3 Replies Latest reply on Apr 8, 2012 2:30 AM by GuyStevens

    Help with dynamic reports

    AaronRoss

      Title

      Help with dynamic reports

      Post

      hello i need help on a report i am working on.

      below is a screen pic of a table that shows data sorted by dates. I am trying to figure out a way to count each of the dates in the white bar and give me a grand count in the white bar.

      the way i tried is first i created two added fields. count 1 and count 2. count 1 is calulation field that simply adds the num 1 each time data is sorted. count 2 is also a calulation field that counts the number of 1's and should give me a grand total but is only returning the number 1.

      what am i doing wrong? and how can i fix this? all i want is a simple report that counts the total number of dates when searched and sorted.

      EX: lets say i want to search telemarketer John Doe. I put john doe in FIND and it gives me all of John Does sales. I then sort John Doe sale's by date. (below) but i want a grand total number of all the dates.

      mls.png