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

    Set analysis chanlenge

    Tuong Nguyen Viet



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




      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?