Stack graph problem

[#1]

Hi,

I am using a Stack Graph.

The Dimensions are

• Month
• Company Name

My objective is to show the Market Share of each company for a particular month.

I am using the following expression :

sum(sales)/sum(total sales).

However this does not gives me the desired result as every month is not 100% but some other percentage of the total(e.g 13%)

Even the following Expression does not seems to be working :

sum(sales)/sum(total <Month> sales).

Please let me know if you need more information.

Regards,

Rohit

[#2]

My guess, from what you're describing, is that you've got the 'relative' check-box selected for the expression on the expressions tab.

Uncheck it, and the world will go back to normal.

[rwunderlich]

sum(sales)/sum(total <Month> sales

works for me, with, as Ryan suggested, relative unchecked. Check "show in percent" in Numbers tab to get display in %.

-Rob