I have a data model that has data for multiple years. The year is stored in a field called custOutcomeYear. I would like to create a chart that only sum current revenue data for the current year. The current year is in a varialbe called vCurrentYear. Can this be dine using set analysys? If so how??
set analysis is indeed far more performance efficient.
i wanted to provide an example, as joestang was new to set analysis.
so, if your set analysis seems not to be working, try the more simple example to test your parameters. if they dont work with the "sum(IF)" example, the problem is not in set analysis, but in the parameter.