Actions on data cells
When you click on the data cell in the data table, these actions are available:
- Replace Values
- Replacing values is similar to write back, but you can decide how to distribute values in a report according to a variety of rules. See Replace values.
- Zero Suppression
- You can enable zero suppression on rows, columns, or both rows and column. For some types of analysis, zero suppression option on categories, series, or categories and series is available instead. See Zero suppression.
- Note
- Additionally, you can add a note to the table cell in ad-hoc analysis. After adding a note, a small triangle in the top right corner of the cell indicates that a note was added. You can edit, view, or delete the note.
- This option is only available when you explore your data with the ad-hoc analysis. See Explore your data.
- Replace Values
- Replacing values is similar to Splashing, which distributes values in a report according to a variety of rules.
- This option is only available when you explore your data with the ad-hoc analysis. See Replace values.