Hi,
I have data something like as shown below (it's a sample data)
| Plan | Month | ID | Value |
| Standard | May-16 | 1 | 10 |
| Standard | May-16 | 2 | 20 |
| Variable | May-16 | 3 | 30 |
| Variable | May-16 | 4 | 40 |
| Variable | May-16 | 5 | 50 |
| Variable | May-16 | 6 | 60 |
| Standard | Jun-16 | 1 | 10 |
| Standard | Jun-16 | 2 | 20 |
| Variable | Jun-16 | 3 | 30 |
| Variable | Jun-16 | 4 | 40 |
| Standard | Jun-16 | 5 | 50 |
| Standard | Jun-16 | 6 | 60 |
| Standard | Jul-16 | 1 | 10 |
| Standard | Jul-16 | 2 | 20 |
| Variable | Jul-16 | 3 | 30 |
| Variable | Jul-16 | 5 | 40 |
| Variable | Jul-16 | 8 | 50 |
| Variable | Jul-16 | 9 | 60 |
I have to show the count of id's in bar chart with alternate states in the expression (Two alternate states and Two expressions).
I have two listbox with Month field (one with alternate state 'State1' and another with alternate state 'State2').
When i make selection in 'State1' Month listbox, then the bars (Expression 1) in chart should show the count of id's for Standard and Variable for the selected month, for ex. May 2016 (Month listbox with State1 alternate state).
When i make selection in 'State2' Month listbox, then the bars (Expression 2) in chart should show the count of id's for Standard and Variable for the selected month, for ex. Jun 2016 (Month listbox with State2 alternate state) but those id's which are present in May 2016, only those id's should be counted in expression 2 (Jun 2016) and other non-matched id's should show as others in the chart.
How to achieve this functionality in the chart?
