Hi,
Is there any way to count the number of items in each Percentile band ?
0-5-25-50-75-95-100
1 answer
Are you able to post a workbook?
If not, you will most likely need to create your own calculation to identify the percentile you are after using the WINDOW_PERCENTILE function.
Similar to if you had an average Reference Line across the Table, you could use the WINDOW_AVERAGE to get that number.
