If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Growth rate calculation and hide particular cells on crosstable

Started by qvixote, 06 Jul 2016 04:36:21 PM

Previous topic - Next topic

qvixote

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:

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?