1 Reply Latest reply on Sep 4, 2013 2:03 AM by Christopher Schuck

    table calculation

    Christopher Schuck


      I am having a problem with a table calculation. I need to display the totals of the trip frequency which is calculated based on the trips by license plate number over a time series. I am converting the [number of records] measure to a table calc and adding the [trip frequency] as a calculated dimension with the [license plate] as the defining dimension in the detail. The table calc is not working as you can see from the attached worksheet. It appears the table calculation cannot define the license plate number in order to give it a frequency rating.

       

      I am hoping an experienced user could have a look at the worksheet attached and see why I am having a problem.

       

      Thanks