I have a pivot table that is showing me the correct # of records until I add a specific string field which has a lot of nulls, then the # records only shows those where this new field is not null. I can't see what the issue is, I have many string fields with null in them and all of them display in pivot tables just fine except this one. What am I missing?

Hi Greg, could you try clicking "Show missing values":

Thank you Moises. That fixed the issue. I haven't paid much attention to this property because the null data shows up whether I check this box or not. What is the correct understanding of when this box is needed and when it isn't?

I'm glad it is fixed. The show missing values option works similarly to FOR EACH, which essentially acts as a left join.

FOR EACH

displays attribute values between the first and the last metric values of each metric, including the missing values in between. If any attribute value falls outside of such intervals for all metrics, it is not displayed.

Show all values

displays all attribute values regardless of the metric values available.

That makes sense if I was using metrics. However, I am using a pivot table to show a listing of records and have placed all the fields in the 'ROW' section and no fields in the metrics section. In this type of use case I would not expect any data rows to be missing but there were. There seems to be some quirks in this control when not using the metrics section.