Function Backed Pivot Table is not Showing all the data

Hi, I may be suffering from a similar issue. I am able to select the values fields however no data is showing up! Sometimes I can’t even see the value field option depending on how I write the function.

Can you share how you fixed your issue please