Skip to Content
Former Member
Nov 13, 2008 at 01:56 PM

Count the values of a characteristic


Hi Experts,

I want to create a key figure that counts the number of values of a characteristic in a query.

For example, the characteristic is cost_center. In 2007 there are 3 different cost_center and in 2008 there are 2.

If I select 2007 I want to see the number 3, for 2008 the 2 and for both the 5.

Unfortunately , we still use Analyzer 3.1. I solved the problem for Analyzer 7.0 with a calculated key figure and a formula variable but that doesn't work for Analyzer 3.1

Has anyone got an idea?

Greets, Dirk

Edited by: Dirk Schwarzer on Nov 13, 2008 2:58 PM