Percentage calculation with null Dimension values.

[#1]

Hi

how to get the total with out null values...

Column1 Column2

Sale         20

Share       10

Rev          40

-              10

I need to calculated the percentage not with the column1 having '-' .

%Column 3= Sum(Column2) / Sum(total Column2) which will be

Also I have selected "Supress when value is Null" option  and it is providing me the below result

Column1 Column2 column3

Sale         20            20/100

Share       10            10/100

Rev          40             40/100

But i need to display the chart as below and how can i get it in expressions but not changing in the script.

Column1 Column2 column3

Sale         20            20/90

Share       10            10/90

Rev          40             40/90

Thanks

RK

[CELAMBARASAN]

Try with this

%Column 3= Sum(Column2) / Sum({<Column1={"=not IsNull(Column1)"}>} total Column2)

or

%Column 3= Sum(Column2) / Sum({<Column1={"*"}>} total Column2)

Hope it helps

Celambarasan