Re: Getting Rank analysis using the fractile() function in a calculated dimension to work across ti
Being a SQL God :), I decided to code a stored proc to populate a [YTD quartile] (1,2,3,4) directly into the fact records. Since this now exists as part of the load, I can use it without being a calced dimension. Right now users are satisfied this exists at the region level. If they also want to see it at the salesperson level, I will have to add that logic to the stored proc. So this becomes a workaround.