2 Replies Latest reply: Sep 11, 2013 12:08 PM by Erik van hout RSS

    Add conditional statement (or extend the scroll-bar)

    Erik van hout

      I'm trying to make a dump of one of my tables.

      In the example I've added part of the table (the table I'm working with contains more columns).

      The conditional I'm looking for is that any of 4 fields (actual hours, actual volumes, forecasted hours or forecasted volumes) should contain a value bigger than 0.

       

      Chart A will give me the correct result.

      However as all of the other records are added as dimensions I can't get the layout of this chart right.

      I would like to add a scrollbar underneath the dimensions.

      Is this possible?

       

      Alternatively I could add many dimension as an expression (as done in Chart B or in table 1)

      This will improve the layout - but I can't figure out what conditional statement must be added to leave out the extra record (containing only 0-values for the 4 fields (actual hours, actual volumes, forecasted hours or forecasted volumes).

      Can anyone help me out with the conditional statement?