I want to create a stacked graph to check the region wise sales pipeline.
Expression: Sum of amount of deals (both sold and pipeline)
I want to keep the graph to show just Sold deals at the beginning. And give the user an option to add a pipeline of his choice (there are 3 stages in pipeline).
If a user wants to see the pipeline of say stage 1, he will choose the stage and it gets stacked over the graph for sold. He can add all stages to the the graph to be stacked with sold, or select any of the stages.
Any help on this will be highly appreciated.