I have been following the advice of many threads on a custom sort option but have not been able to figure this out. All the values in the chart show as the same height (the total record count) instead of their respective values by category. What I have:
- Table filled with 76 records, relevant to this question is the column "From Stage" which has 3 possible values
- BANT Complete
- Proposal/ROI
- Negotiation/Review
- Table (Manually Created) that links to "From Stage"
- Stage (populated with 3 rows, of the above values)
- Sort Order (populated with 3 rows, values of 1-2-3)
- I created a chart and used the manually created table's "from stage" as the x-axis and for the y-axis the count of "from stage" from my record filled table
- The result is 3 columns
- BANT Complete -76 Records
- Proposal/ROI - 76 Records
- Negotiation/Revie - 76 Records
Any idea why that is not filtering correctly? I expected to see:
- BANT Complete -21 Records
- Proposal/ROI - 36 Records
- Negotiation/Revie - 19 Records
