Why does the Variable filter not work in the E() statement but it works in the last expressionw ithout the E() function?
Returns No Data when using the variable but if I hard code the filter with the same value as the variable instead of using filter, it works:
=sum({$<[VAR Reporting Name] = E({$1<Manufacturer = {'$(vManufacturer)'}>} [VAR Reporting Name])>} Sales) / 1000
The variable works in this instance below:
=sum({$<Manufacturer = {'$(vManufacturer)'}>} Sales)