How to calculate the total sum of sales of all the products in table chart

[#1]

Hi,

I am using straight table with product in dimension and their sum(sales) in expression

i need to calculate the marketshare of the product,as

selected product sales / sum(sales of all the products).... especially total sales i needed

how to do this in expression field,i used set analysis also

how to calculate the total sum of sales of all the products

thanks

[#2]

Hi,

use the expression

sum([product sales])/ sum(total [product sales])

the keyword 'total' will give the total sum of all the products...

Regards,

Nilupa

[#3]

Hi,

You can do following.

selected Product Sales/Sum(<Total>Sales)

If you face error, plz share sample data.

Happy Thoughts

[#4]

Hi,

I am getting some answer like #####

How to remove this and show the answer in two decimal values

[jonathandienst]

On the chart properties, go to the Number tab and set the format to Fixed and set the number of decimals places to show.

Jonathan

[#6]

Hi,

That may be no enough space in the chart to display the values.. just resize the column and see..

In number tab you can change the number format.

Regards,

Nilupa