4 Replies Latest reply: Oct 2, 2015 3:55 PM by Camile Johnson RSS

    Dynamic Expression Change in Straight Table

    hgdfs fgdgdgd

      Hi All

       

      1.jpg

      This is my data in excel file.

      i created a straight table like below

      2.jpg

      i want to change my 2 columns in the table dynamically to BudgetSales and Budget Revenue by using a list box in UI,like

      Act.jpg

      Bgt.jpg

      i had done dis script in Edit script

      LOAD * INLINE [

          Filter, FilterNo

          Actual, 1

          Budget, 2

      ];

       

      but while changing expresions in chart

      im not getting the result

      some thing is wrong in my expression like

      =if(GetCurrentSelections ('Budget'), Sum ([ActSales]),Sum ([BudgetSales]))

       

       

      pls give me the ideas