5 Replies Latest reply on Jan 24, 2018 12:25 PM by arvindgarg

    Hi Everyone

    rajesh reddy

      I have got a complex case, let us assume 3 columns

       

      Fact A : Percentage of an average 

      Fact B : Sum in $ amounts.

      Dimension : %,$

       

      My case : I have to merge these 2 facts into 1 column based on the dimension.

      Condition : If dimension is $ then the it should be Fact A% else Fact B$.s

       

      Dimension    Column

         %                  20%

      $                      100%

      %                    30%

       

       

      Ideas are welcomed.