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?
Edited by: Dirk Schwarzer on Nov 13, 2008 2:58 PM