Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to create a report looping over tertials (grouping of 4 and 4 month). I have done that, so far so good. Then the problem emerges, there are too many values of "Clubs" in one chart. Is there a way I can limit the clubs to 3 or 4 for each chart? Meaning that I want to have two charts instead of one.
I am aware that I can create two different charts with the Club-={clubname} and in that way limit the clubs for each chart. But this is not a dynamic way of doing it. Can I have a function sorting alphabetically including the first 4 clubs, and then the next 3 in a new chart?
Thanks
Ideally I want to limit the dimension based on alphabetically order, showing the first 5 values.