Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following list box:
I have the following chart:
The results I am looking for is to drop the list box and have a separate chart for each of the clusters. Is that possible? I know that if I select different items in the list box the chart values change but I dont want that.
Thanks,
David
Yes thats possible. In the expressions you can use hardcoded Set analysis.
Example
Sum(<{Cluster={'Rio'}}>Cost) This would be for first chart for Cluster Rio.
Sum(<{Cluster={'West Mesa'}}>Cost) This would be for second chart for Cluster West Mesa and so on.....
Thanks
Yes thats possible. In the expressions you can use hardcoded Set analysis.
Example
Sum(<{Cluster={'Rio'}}>Cost) This would be for first chart for Cluster Rio.
Sum(<{Cluster={'West Mesa'}}>Cost) This would be for second chart for Cluster West Mesa and so on.....
Thanks
Thank you Ajay. I tried your example before I asked the question and it did not work. I see now where I went wrong.