1 Reply Latest reply: Feb 8, 2018 11:55 AM by Sunny Talwar RSS

    Set analysis chanlenge

    Tuong Nguyen Viet

      Hello,

       

      I'm facing to this chanlenge. My data have 5 field

       

      IDTypeDateAgeValue

       

      I would like to have a  formula to sum the value with fixed Type and Date. Age can be selected in dashboard.

      So I do

      1.   sum({1<Type={1},Date={201801>}Value)  => Age cannot be selected

      2.   sum({$<Type={1},Date={201801>}Value)  => We can select all Type, Date, and Age => so Type and Date cannot be fixed as I want.

       

      Do you have any suggestion to solve my problem?