Hello all,
I need help with tips on how to show values generated from grouped data value onto a columns or bar chart.
In my case, I have a field for gender that accepts either F or M for female and male attributes, and using query I have grouped data on this table to provide data that shows the number of females (F) and males (M). This works well with a report, but on charts seems to pick up the only one of the values depending on how it is sorted. How do I go about this to show both females and males as multiple Y-axes and stacked chart as they are not separate data series but one?