7 Replies Latest reply on Sep 4, 2018 9:14 AM by Manoj Dixit

    In report data need should show in single row

    Nikhila reddy

      Hi Everyone,

       

      i need help in Modeling RPD or report.

      Below is the table structure which gives Current tier, End of last month, End of last month previous year.

      i modeled it in Logical layer, by using case statement.

      (Case when Time_period='EOLDM' then Tier_name end) which gives me EOLM Tier Name.

      same way for current and EOLMPY.

       

      But am able to see report in the below format,

      What need to be done to see them in single row.

       

      Thanks,

      nikhila