Hi
I'm developing a hierachy system that needs display data from a database,
summing from the lowest level up. The difficulty is, there are also multiple
columns across, I'll try to show it below:
col1 col2
col3 col4 col5
Level1
Level1.2
Level1.3
Item1
Item2
Item3
Level2
Level2.2
Level2.3
Item1
Item2
Item3
What I've tried to draw above is best to think of as sort of a spreadsheet.
Each value of the items at Level1.3 should be summed at Level1.3 and each
LevelX.3 should sum to the level above. Preferably the whole thing should be
collapsable in the browser, but thats another thing. The data that comes
from the database is at the Item level (each Item represents a record in the
table holding the fields col1, col2, col3, col4, col5).
I hope this makes sense to someone out here, because I doesn't to me
anymore! Please help me out here...
Thanks