Running total %

[SAWB]

In an inventory report, I have two running totals. One counts on hand inventory by color (RT1), and the other by style (RT2).

I want a formula to calculate the percent of on hand by color in relation to on hand by style.

When I create a formula ((RT1 / RT2)* 100), the first color in a style is 100%, and the last one is correct.

How can I do this?

 

[Tremplo]

Try grouping by style then color. Then use summary of count.

 

[SAWB]

I don't quite follow you on this one...