I have the above visualization in my quicksight
PASSED & FAILED values are calculated field filtered out from other dataset, involving ‘distinctCountOver’ and ‘ifelse’
However, whenever I collapse my table, the total/count doesn’t provide the exact output I wanted as shown in the desired output
How can I achieve this?
Or is there a way for me to created another calculated field to output the total sum for each class?
Thank you