Topic
  • 1 reply
  • Latest Post - ‏2013-05-01T15:10:44Z by DanielWagemann
jsellner
jsellner
32 Posts

Pinned topic Cross Tab Help

‏2013-04-24T18:54:28Z |

I have a crosstab report that is displaying the # of crashes and calculating a Rate of crashes per day based on the month and severity.  The report looks okay except for the columns total (Severity) for rate per day and total/total rate per day are totals instead of calculation.  See Attached file

The Rate per day is calculated based on the # of crashes / # of days in the month.  In the total column instead of a calculation it is doing a total.

I also need to display the # of days in the year which is a total of the # of days per month.

The package is a DQM package

 

Attachments

  • DanielWagemann
    DanielWagemann
    850 Posts
    ACCEPTED ANSWER

    Re: Cross Tab Help

    ‏2013-05-01T15:10:44Z  

    The product is doing what you asked it to do... you asked for the total by doing the total summary.  If this is not what you are looking for, change the aggregate summary function property for each of the columns from automatic to the desired roll up... total for the columns to be totalled and cacluated for the rate calcs.  Then instead of Total, use the Summary or Aggregate (off the toolbar) summary function to generate your summary row.

  • DanielWagemann
    DanielWagemann
    850 Posts

    Re: Cross Tab Help

    ‏2013-05-01T15:10:44Z  

    The product is doing what you asked it to do... you asked for the total by doing the total summary.  If this is not what you are looking for, change the aggregate summary function property for each of the columns from automatic to the desired roll up... total for the columns to be totalled and cacluated for the rate calcs.  Then instead of Total, use the Summary or Aggregate (off the toolbar) summary function to generate your summary row.