Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See attached
Modified my solution after you added a picture
I have been doing same but get 100%in all
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.
Hi,
Try using something like this:
sum(sales)/Sum(TOTAL <MONTH> sales)