
Re: Chart Percents
Dmitry Gudkov Feb 20, 2013 4:22 PM (in response to Pamela Patena)What is your expression for the chart above?

Re: Chart Percents
Pamela Patena Feb 20, 2013 4:44 PM (in response to Dmitry Gudkov)I'm using a sum(amount)/sum(total amount)

Re: Chart Percents
Rebecca Molstad Feb 20, 2013 5:28 PM (in response to Pamela Patena)See either of these two graphs help. Not sure I am entirely clear on what you are looking for.

Test.qvw 983.5 K

Re: Chart Percents
Pamela Patena Feb 20, 2013 5:39 PM (in response to Rebecca Molstad )that's, the type of chart I'm looking for, but instead the units on the y axis, i need the percent of the selected supplier.

Re: Chart Percents
Rebecca Molstad Feb 20, 2013 5:46 PM (in response to Pamela Patena)Something like this?

Test.qvw 985.0 K

Re: Chart Percents
Pamela Patena Feb 20, 2013 5:59 PM (in response to Rebecca Molstad )Mmm no, let me see if I can explain it better.
The chart using the product category will show me the data based on a 100%
Category
Percent A 40% B 25% C 35% We get the 100%
However, each product have their supplier and a supplier can provide products of each category.
Supplier 1 supplies the 50% of my products, in this part we're not taking in count the category of the product.
If I select Supplier 1, the chart gets this information:
Category Percent A 50% B 20% C 30% But the way it need to be show is like this:
So, if i select the Supplier 1, the chart should show me the next information
Category Percent A 25% B 10% C 15% This gives me the 50% of the Supplier 1, instead of taking it like 'a whole 100%'






Re: Chart Percents
Alessandro Saccone Feb 20, 2013 4:23 PM (in response to Pamela Patena)Surely you can work with properties of the chart, I should prefer to add as many colums as suppliers where in each column i compute the product of the original value multiplied by 50%, 10% and so on in order to use new columns to make graph

Re: Chart Percents
Pamela Patena Feb 20, 2013 6:19 PM (in response to Pamela Patena)For anyone who might need something like this, it worked the advice of multiply the result for the percent of the supplier, it ended looking like this:
(sum(Amount)/sum(TOTAL <Year_Month> Amount)) * $(vSupplierPercent)
Where vSupplierPercent is for getting the decimal part of the supplier:
sum(Amount)/sum({<Supplier=>}Amount)