1990 1991 year <===== dimension
north sales 10 8
cogs (5) (4)
south sales 6 5
cogs (2) (1)
region line item <========== dimensions
I just want to be able to specify different dimensional values and get back
rectangles of data that I can manipulate. I've already done the manipulation
stuff so it's just how to layout the data.
Query examples would be...
total = north + south returning 9, 8
total cogs = north.cogs + south.cogs returning -7, -5
1990 returning 10,-5,6,-2
north:1991 returning 8,-4
north:1990..1991 returning 10,8
Once you've created region I don't think you can delete it and all it's
entries cos that would delete everything i.e. I believe you have to leave at
least one value in the column whether it be null or north.
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
