4 Replies Latest reply on Sep 26, 2018 11:06 AM by Naveen B

    How to only show relevant dimensions that cover 4 consecutive years?

    Mark van Enckevort

      Hope you can help me with below question:

       

      In below table I have 6 city-to-city lanes with their annual volumes. As you can see, in some occasions the values of a certain is left empty.

      Table example.JPG

      I want to change the view to the lanes that did only had a value in each year. In this occasion that would be only lane 2 and lane 6.

       

      Did someone had to do this exercise before? and how did you solve this?

       

      Thank you for helping out!

      Mark