Set Analysis Question

[Anonymous]

I have sales person and month as dimensions and sales of Product_A and Product_B as measure. I want ultimately create a bar chart to display % of product sales per month see below

Can some one help?

Data in the table

and ultimately a bar chart like

[Anonymous]

See attached

[Anonymous]

Modified my solution after you added a picture

[Anonymous]

I have been doing same but get 100%in all

[Anonymous]

That means you're doing something differently.  Try to compare carefully, or upload your app and I'll take a look when I have time.

[punitpopli]

Hi,

Try using something like this:

sum(sales)/Sum(TOTAL <MONTH> sales)