Question:
Can anyone help me with a Calculated Key figure issue I'm having please?
My Key Figure is defined as : count ( 'LW Estimated Sales £' > 10000 )
At the lowest level this gives me data as required I.e. it places a 1 in the column if the sales > 10000. However in the Result it also places a 1 when I actually want it to add up all the 1's. I have tried changing the calculation properties to no avail.
Has anyone got any ideas?
Answer:
Hi nspvfc,
after you create your calculated key figure and you move it in columns, you can modify his properties and set "Calculate Result as" as summation or count.
Bye
K