I have a dynamic calculated dimensio(Age band)n in bar chart.The values are N/A, 1 to 30 days, 31 to 90 days, 91 to 180 days, 181 to 365 days, 366 days plus based on Age field. N/A will capture -ve values of Age. Iwant to order the data in bar chart based on ageband in the same way mentioned above. But unable to sort by using sort tab options. Can any one help? Good thing is the ageband values are fixed. No additional values will be added.
This solution uses the dual function to create underlying numerical values for unequal sized buckets so that sorting needs no special sorting expressions.
