Adding color to cells

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