Pivot wont show the only value that is needed when drilling down

Hello Masters,

hope you are all well, i am trying to do something in excel. please excuse me if i can't explain it in a very short manner.
i want to create a pivot that shows the sum value of the columns (Fruits) that has formula on the raw file (see image 1) and create a pivot chart as well.

image 1.png

i created a formula so that the raw file can distinguish if which rows does have the specific fruits and it works fine (eg. if Apple cell = yes, else = no).

but the problem is, when i tried to make it as a pivot it is counting all the values since it has formula. so what i did is instead of using Yes and No i used number "1" so i can just sum it up.
and it works (see image 2)
image 2.jpg

now after creating a pivot it i added a pivot chart - now this is the biggest issue, when i double clicked (Drill down) the value on pivot instead of showing which rows has those value( which is i expected) it is showing the whole raw data. i am thinking maybe because technically it has values (Formula) even if its blank.
image 3.jpg

It's not due to the formula, it's due to the fact that all those rows exist for that field - there is no filtering in place. You'd need to use PowerQuery to unpivot the fruit columns into rows and then filter out the null values.