Within the "Select Data for Pivot Table" settings dialog for reports, have "Checkmark" as an option for the "Within Cells" setting
When I have a pivot report -- sometimes for brevity (depending on the audience), I just want to show that something would be populated in a cell -- without specifically showing the content.
Presently, I use the "Count Unique Cells" options for the "Within Cells" setting for the report as a work around, which will put a "1" (in the case of my report) in the cell.
If a new "checkmark" option were chosen, the cell would only show a checkmark (perhaps the Unicode Character 'CHECK MARK' (U+2713)), instead of any content. Lack of content would leave the cell blank.
See screenshot of my Pivot report's configuration below (we renamed "goals" to be "objectives" in our instance). I also put a screenshot of the rendered report.
-
ADMIN RESPONSENov 18, 2019
Thank you for the idea. Given the work around noted and historical support for this idea, we are unlikely to add a checkmark option within pivot cells. We hope you can understand.
© 2025 Aha! Labs Inc.•All rights reserved
Update: I mentioned we renamed goals to objectives. We also renamed Features to Epics. Letting you know so the screenshots make sense.