Running difference: Negative values in brackets and red

Business owners need to see the sales figures by months and their month-on-month difference.

If the difference is negative (fall in sales) then it needs to be shown in red and values need to be in brackets.

Getting ready

Create a simple list report with Time Dimension | Current year, Time Dimension | Current month, and Sales fact | Quantity as columns.

Group Current year and sort Current month ascending.

How to do it...

1. Add a new query calculation to the list. Define the expression as:

   running-difference([Quantity])
   

   Call this item as "Running Difference".

2. Open the Data Format properties for this calculation from Property list.

3. Set the Format type as Number and the Negative Sign Symbol as brackets ().

   

4. Now go to Condition Explorer and create a new condition variable of Boolean type. Define the condition as:

   [Query1].[Running Difference] < 0
   

   

5. Call the variable as Show_Red.

6. Now go back to report page and select the Running Difference column...