Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a problem with SetAnalysis where he is only considering the last Type2 of table, not respecting the selection of Type2 showing the sum of the last
Type2 in all dimensions ... Does anyone know what the problem ? Thanks.
Expression: Count({$<Table1.Type = Type, Table1.Type2 = {$(=Maxstring([Type2]))} >} Distinct Table1.Key_Employee ) ) )
Count({$<Table1.Type = Type,
If Type is a dimension in your chart then you can't use it in the set analysis expression. If Type is a field and there is only one value selected you need to change it to Table1.Type = {'$(=only(Type))'}
Table1.Type2 = {$(=Maxstring([Type2]))} >} Distinct Table1.Key_Employee ) ) )
Same here. If Type2 is a dimension in your chart you can't use it in the set analysis expression. If it is a field then enclose it in single quotes.
Table1.Type2 = {'$(=Maxstring([Type2]))'}
It's also not clear to me if Table1.Type is the same field as Type or a field from another table.
Thanks for the Reply...
Type is a field of another table...