Component Solution Services REC02F Manual do Utilizador descarregar pdf (Página 58)

Tips Recipes Brio 2002

Section Type: Pivot section

Tip Name: Profit and Loss Reporting

Purpose / Use: To create a display that shows both debits and credits as positive

numbers, while displaying the correct totals at the same time.

Sample File: Not Available to the Public

Steps to Produce: The solution is simple once you remember that display formatting is a

separate issue from the actual internal numeric representation.

1) Build your pivot as you normally would.

2) Select each of the numeric facts, right-click and select “Number…” from the speed menu.

3) Select the “Custom” category and create a new custom format as:

#,###.0;#,###.0

In other words, the negative value format is set identical to the positive value format.

4) Click “OK” to apply the new format.

5) The Spotlighter can be used to add color highlighting so that, if desired, conditional

formatting can still identify negative numbers.

1 2 ... 53 54 55 56 57 58 59 60 61 62 63 ... 77 78

Sem comentários

Component Solution Services REC02F Manual do Utilizador Página 58