Qommentary
Qommentary Pivot Table
Qommentary Pivot Table
  • Getting Started
    • Embedding a new extension
    • Updating API endpoints
  • Setting up your table
    • Adding dimensions
    • Adding measures
    • Adding color to cells
    • Fully expanded view
    • Indented rows view
  • WORKING WITH DATA
    • Adding comments to cells
    • Pivoting dimensions
    • Resizing table columns
  • Managing security
    • Security roles
    • Security permissions
  • Support
    • Submit a ticket
Powered by GitBook
On this page

Was this helpful?

  1. Setting up your table

Adding color to cells

PreviousAdding measuresNextFully expanded view

Last updated 3 years ago

Was this helpful?

Color is a powerful visual indicator which can help identify change or trends over time. The Qommentary Pivot Table allows you to add custom background and text colour to dimensions and measures.

To add color to your cells, follow these steps:

1. Click on Edit sheet button

2. Expand the dimension/measure properties

3. Scroll down to the Background color expression property and enter a value or expression

4. Scroll down to the Text color expression property and enter a value or expression

The pivot table will now evaluate each cell expression and display the relevant colors