How does Expression work ?

[#1]

Hi All,

As shown in the graph below is it possible for me to get the count(individual record) * 100 / sum (total record)  in the same graph?

[SunilChauhan]

(count(distinct record) * 100) / sum (total record) 

[amit_saini · Accepted solution]

Sai,

As Chauhan suggested it should work.

Thanks,
As

[#4]

Sum(dimension) does not return me any value when I use it in expression. I have only one dimension to it. To be more clear.. this is how the data looks.

Sales person          Sales

A                              2

B                              12

C                              11

..                                 ..

when I plot the graph against sales person Vs sales and I try to get the expression % sold with count ( A) * 100 / sum (A+B+C). I do not get any value. I do not get any value when I try to get only the Sum(Sales). Is it wrong with the data ?

[amit_saini]

Sai ,

Like this???

Thanks,

AS

[#6]

Thanks All. It was my mistake.

[amit_saini]

Good