A specific, tricky symptom sometimes shows up in Zoho Analytics pivot tables: drill-through (View Underlying Data) works correctly for most cells, but returns a blank result for a specific combination, such as a particular category value crossed with a particular status, even though the pivot's summary total for that cell shows a genuine, non-zero count, and the underlying rows are visible elsewhere in your data.
A note on sourcing: We couldn't find anything in Zoho's own documentation specifically describing this behaviour. The explanation below is reasoned from how Zoho Analytics' drill-through mechanism generally works, not a confirmed diagnosis from Zoho itself. Treat each cause as a hypothesis to test in order, not a guaranteed answer.
Cause 1 (Most Likely): The Underlying Records Sit in a Source Table Excluded from This Pivot's Build
If the report is built from a Query Table (SQL) or a merged/unioned table pulling from several source tables, drill-through only works cleanly if it can trace each aggregated row back to a specific base table. If the records behind the problem cell happen to sit in a source table that wasn't included in the join or union feeding this particular pivot, Zoho counts them correctly in the summary total but returns nothing when you try to view the rows behind that cell. This would explain why the missing rows are visible elsewhere in your data but not through this specific drill-through.
To check: Open the pivot's underlying source, via the Data tab or the report's Edit Design settings, and see whether it's a single table or a Query Table with multiple joins. If it's a Query Table, check whether the affected records are present in every table involved in that join.
Cause 2: A Formula or Lookup Column Is Being Used for Grouping, Rather Than a Raw Column
If the field you're grouping by in the pivot is a formula column, for example one that buckets many raw values into a smaller set of categories, drill-through can sometimes fail to map back to the base rows reliably, particularly if the formula involves conditional logic or a lookup from another table. One category might work correctly because it pulls straight from a raw column, while another category's classification might go through a formula that breaks the trace, which would explain why the problem is isolated to one specific value rather than affecting every cell in the pivot.
To check: Right-click the relevant column header in the pivot's source table and see whether it shows as a formula or lookup column, versus a plain text column.
Cause 3: A Mismatch in the Underlying Values Themselves
Even when the values look identical at a glance, a hidden difference is possible: a trailing space, a different letter case, or a blank cell that's been relabelled by a "Display Unknown value as" setting can all cause the exact-match filter used by drill-through to fail, even though the aggregate count itself is genuinely correct.
To check: Use View Underlying Data from the toolbar directly, rather than by clicking the specific pivot cell, and manually filter for the exact category and status combination in question. If that manual filter also returns nothing, you've confirmed the values genuinely don't match at the row level, and can go looking for the specific discrepancy (spacing, casing, or a relabelled blank).
Suggested Order of Investigation
- Check the pivot's data source structure first (Cause 1), since it's the most likely explanation and quickest to rule in or out.
- Check whether the grouping column is a formula or lookup (Cause 2).
- Manually filter the underlying data to confirm or rule out a value mismatch (Cause 3).
Need help? 1 Cloud Consultants can help you diagnose drill-through issues in Zoho Analytics pivots, including tracing data source joins and formula column behaviour.
Book a discovery call with 1 Cloud Consultants.