5 Replies Latest reply on Jan 2, 2019 2:27 AM by Ombir Rathee

    LOD /Table Calculation issue for selecting only one value in row level and other value at column level

    Jinson Fernandez


      I have a data source which shows all the credit information along with a filed ON_OFF_Bucket which tells whether the aggregated stat belongs to that member-On or not- OFF



      This is how I want the data to be shown


      This is how my workbook view looks as of now fom which i want only ON data at column level and corresponding OFF data at row level

      And this is how my actual data source looks like



      I guess need to write some fixed LOD or some other table calculation to achieve this.

      Kindly help me out on this