Say I have the following table:
id area product_sold number_sold
1 north productA 1
2 north productB 1
3 east productA 1
4 south productB 1
5 east productA 1
6 north productB 1
7 south productA 1
8 west productB 1
9 east productA 1
10 north productB 1
I want a bar chart that shows the percentage of product sales by area, and I'd like the chart to be responsive to page controls. So for example, with the above area "north" has sold 1 of 5 (20%) for productA and 3 of 6 (50%) for productB.
I'd like these same numbers to be available when page control is added and a user selects "north" only from the control.
The problem I'm currently having is I haven't discovered a way to retain the sum of the total sold for all areas once the page control selection is in place.