How can I add a percentage line after or bevor a subtotal
Hallo NG, How can I add a percentage line after or bevor a subtotal. Maybe a second line Subtotal with percentage? Example: ---------------- Region Munich Title x y ShopA 1000 200 ShopB 2000 200 Sum 3000 400 Percentage 50% 50% of Total (Question How?) ---------------- Region Salzburg Title x y ShopA 1000 200 ShopB 2000 200 Sum 3000 400 Percentage 50% 50% of Total (Question How?) ---------------- Total 6000 800 ----------------
TABLE FILE xxxx SUM x y BY region NOPRINT ON region SUBTOTAL x y
Thank you, Alfred
February 18, 2005, 07:24 AM
HÃ¥kan
Alfred,
try this:
ON TABLE SUBFOOT "Sum : <ST.value" "Percentage : <PCT.value"