Am using Fixed calculation where i am using dimensions where some are single select and some are multiselect on the dashboard. when using dimensions of single select filters alone in the fixed calculation, the denominator is not changing w.r.t to dashboard filter say 'number'. If i add additional dimensions which are multiselect filters on the dashboard in this fixed calculation, denominator will change w.r.t the same filter 'number'.
Does adding dimensions which are multiselect filters on the dashboard in Fixed calculation cause any inconsistency? Is there anyway the dimensions i am using in the fixed calculation either single select or multiselect or combination of both doesn't change the output.
very hard to see what is wrong. Fixed calculation works the same irrespective of the filter selection mode (single or multi). Can you share a sample workbook?
