Hello All,
I have a query in the format
Month Type TypeCount
2 A 3
2 B 4
2 C 5
3 A 4
3 B 4
3 C 6
4 A 7
4 C 2
4 D 1
I want to create charts (or pivot chart view) such that first chart display data only for A - that is, count of Type for each month, then another chart with data only for B and then another chart only for C. Is it possible? Also, I want these three charts on the same report/form - which ever is better.
Kindly let me know ASAP.
Any input (or a better way to get what I want) is appreciated