Preserve sum() when selecting a field

[sifatnabil]

Hi all,

In my stacked bar chart dimension, I have MonthYear and Client, and in expression, I show % VOLUME per client per month:

sum(VOLUME)/sum(TOTAL <MonthYear> VOLUME)

Now, there are 50+ clients. I want to show just a select few clients of my own choosing. Selecting those clients changes the % values completely. Is there a way to preserve the value of sum(TOTAL <MonthYear> VOLUME) when selecting clients?

[swuehl · Accepted solution]

sum({<ClientField= >} TOTAL <MonthYear> VOLUME)

[sifatnabil]

Thanks - I was trying to put that set after TOTAL instead of before. Also, the legend of the bar chart still shows all 50+ clients. Is there a way to change the legend to just my client selections?

[swuehl]

I can't reproduce your issue with the legend.

Could you post a small sample QVW that demonstrates this?

[sifatnabil]

Actually I restricted the legend by doing dimension limits on "Show only largest 11 clients", which worked. Thanks!