I have a scenarion where I have divisions like 10 divisions with sme 200 products all the products are attached to some or the oter division we call it as base division but a single division can market other division products also so in a financila year suppose sme A division does a business of 1000 crores ,
I have to show it in a straight table or pivot table contribution of all the division towrds the total business suppose base division here is 900 crore rest is contribyted by pther division.
The expression to calculate the business i am using is