Hello,
I am trying to do a Faceted search but its not meeting my requirements. I want the count on Facets to be from a different column in same table instead of total number of records. For example in below page the Female count is 97(total records with female is 97). But I want to display this value with a column from OBS
Instead of counting the number of Female, I want the count from sum(OBS).
My demo application is here→https://apex.oracle.com/pls/apex/r/kanchana/demo-kc/facet
user- tst_user
password- Demo123!
Appreciate your help!
Thanks!