I have a horzontal bar graph that shows the number of customers (count distinct custnum) in a revenu bandwidth (0-20k, 20-50k and 50k+) The bandwidhts are in a calculated dimension using the dual function. Now when I select 1 revenu year (2014 or 2015) the number of customers show correctly. But selecting 2 revenue years, to show the growth of the number of customers in a revenu group between the 2 years, the graph is messed up. My guess is that the revenu is combined over 2 years and performs funny things on the count per bandwith because the year is a dimension and not part of the dual calculation.
Any ideas how to resolve this??