4 Replies Latest reply: Nov 28, 2013 8:28 AM by Friedrich Hofmann RSS

    Use the TOTAL qualifier only on part of the dimensions

    Friedrich Hofmann

      Hi,

       

      I have a straight table with the details of accidents which are ultimately taken from an Excel list. This straight_table_diagram has several dimensions:

      - Date

      - Plant

      - Area

      - Number

       

      One of the expressions I have is "nr. of events". Currently,  because of those dimensions, that is always 1. That is not very helpful. I would like to disregard all dimensions except the Date and display that as the nr._of_events, that would be more meaningful.

      Can I do that using the TOTAL qualifier? In my book, there are a few examples on that one, it's easy enough, but the examples are only to disregard all of the dimensions.

       

      Thanks a lot!

      Best regards,

       

      DataNibbler