7 Replies Latest reply on Aug 14, 2018 7:28 PM by Ashok Ramineni

    Switching Columns dynamically

    Ashok Ramineni

      Hello,

       

      Can you please help me out with the below scenario.

      For reporting purpose I have pre calculated the data and kept it as a columns. i.e. LSA & FSA.

       

      When a user logged in (1234), has 4 rows.

      And relevant values should get filtered be displayed from aggregate data. i.e.

       

      My requirement is :

      When user(1234) selects "All" Transportation, below are the results which can be derived from MAX(LSA) at each month, Transportation, Region level.

      When user(1234) selects any of the Transportation i.e. Ground/Water/Air then below data should be displayed..

       

       

      Appreciate it!!!!

       

      Thanks.