Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone know how to draw a line or bar chart to show a specific info in that chart, without having to clik on d list box
for example, a list box contains
GAMES:
How do you draw a chart to only show xbox in a year, when you also have the month list box
Dan
I'm not sure exactly what you're asking for, but maybe something like this?
sum({<Games={XBOX},Year={2009},Month=> Amount)
That says to ignore what you've selected for Games, Year and Month, and substitute XBOX and 2009.
For example, if you have these two list boxes or fields with the content
GAMES: MONTH: Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec
How do you draw a chart to only show xbox across all months, without having to put both list boxes and then click XBOX, to show on the chart
Dan
Dan, just so I understand, does each of the 'games' normally generate a line or bar on the graph? Normally, you have (*counts games*) 7 lines or whatever and you want to only have a single line based on what you select?
Yes, each of them would normally generate a different line or stacked bars. And I want it to just draw 'a' game for 'all' months, without having to click in the games list box.
Dan
I'll refer you back to my earlier post then. It sounds like I understood what you needed, and that should be the solution. Or if you have a version earlier than 8.5, something like sum(if(Game='XBOX' and Year=2009,Amount)).