Set analysis chanlenge

[Anonymous]

Hello,

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

ID	Type	Date	Age	Value

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?

[sunny_talwar · Accepted solution]

Not entirely sure what you want, do you want to ignore selection in Age field in addition to the set analysis on Type and Date? May be try this

Sum({$<Type={1},Date={201801}, Age>}Value)