Hi all,
I have the following expression:
sum({StateB<CompanyName=$::CompanyName, Month=$::Month>}SalesAmount)
In the above expression I am getting my chart to pick up selections in CompanyName and Month as well as selections from objects in StateB.
Is a way to get the set analysis to pick up selections from objects that are not in StateB without having to specify the fields?
E.g.
Year is in StateB
I want the chart to update when someone selects something in Year
but also the chart should update when someone makes selections in any field that is not in StateB without having to specify the fields in set analysis.