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

    Dynamic Expression Change in Straight Table

    hgdfs fgdgdgd

      Hi All



      This is my data in excel file.

      i created a straight table like below


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



      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