Pivot Enhancements

Display Missing Value Option

Zoho Reports now supports the  Show Missing Values  feature for Pivots too.  Recently , this feature was introduced in charts. This allows you to view the in-between missing values in your data.  This can be applied on a  Date   or a  Category  column.

So far when you create a pivot with a date or category column, if a particular category does not have any value, then the Pivot would skip displaying that data. With this new option you can choose to display the record which does not contain a value. 

You can apply this function for the columns in both "Rows" and "Columns" shelves. You can also enforce hierarchy on the selected columns.  Click to know more .