Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created buckets to get the sales of the top X number of clients in a chart using the following expression.
if (BuckettA = 'Top10', sum({$<Year={2009},Customer = {"=rank(sum({$<Year={2009}>}Sales)) <= 10"}>} Sales)/sum({<Year={2009}>}Sales),
I didn't exactly what you are trying to do. What type of chart are you creating? Is the Customer a visible dimension in the chart? The expression seems ok, but too complex! Try using this sequence SUM( {$...} IF( Bucket..., Sales))
I didn't get exactly what you are trying to do. What type of chart are you creating? Is the Customer a visible dimension in the chart? The expression seems ok, but too complex! Try using this sequence SUM( {$...} IF( Bucket..., Sales))