Struggling a little bit with some bucket analysis using a calculated dimesnion. Simple example qvw attached.
Basically I can define the bucket as a calculated dimesnion. The chart seems to correctly count the number of IDs that fall in each bucket for each year, but when I try to calculate the TOTAL Ids for the year (in order to create a 100% bar chart) it seems to ignore TOTAL <Year> part of the formula and give me the same result as the simple COUNT. Where am I going wrong?