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

      Hi

      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