Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
After a bit of guidance really, and a push in the right direction.
if i have a set of data such as:
Total Sales for ProductA by Year and Total Sales for ProductB by Year
is there a way that i can ask the user to choose from a list of products ( A, B etc.)?
Based upon their choice (multi select) the year would be the dimension along the bottom, and the chosen products would then appear on the bar chart?
I have a feeling i may need to look at conditional expressions, but if anyone has some guidance, i'd welcome it.
Hopefully i have explained it enough, but please kick me if it makes no sense.
Many Thanks in advance,
Jason
This link has a logic for a straight table, but you should be able to port over the functionality to bar chart
Customizable Straight Table
Thanks Sunny T, a definite point in the right direction, should be able to work it out now.
Cheers
