Print Page - Growth rate calculation and hide particular cells on crosstable

Title: Growth rate calculation and hide particular cells on crosstable
Post by: qvixote on 06 Jul 2016 04:36:21 PM

Hello!

I have a report with a crosstable (see attached image) in which I need to do 2 things:

1. Create a growth rate that divide a cell by the previous year, with formula like T1 / T0 - 1:

Code Select


2009  2010  2011  2012  2013  2014  2015
88.9  87.9  99.4  102.8 100   105   109.9
--    -0.02 0.13  0.03  -0.03 0.05  0.04

2. Do not show values in cross between PONDERADOR and totals, and between PONDERADOR and INDICADOR AGREGADO DE ACTIVIDAD.

Any idea?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: qvixote on 06 Jul 2016 04:36:21 PM