Solution Needed

[BeingYogi]

Product	Rate	Total Share	Qty	Sales Total (RateXQty)
Product A	100	25%	?	?
Product B	200	75%	?	?

<tbody>
</tbody>

I have two Product Categories , and their rates
Want to derive
For Product A , What would be the QTY & Sales Total to achieve 25% of Total Sales
For Product B , What would be the QTY & Sales Total to achieve 75% of Total Sales

Actually there multiple Products

Kindly suggest

 

[etaf]

i dont think you can , without a target number of quanty or revenue
ie
25% of what