I've got a situation where, within a single window, i need to have two different (although same columns) queries, and provide a total column to the far right.
I'm not exactly sure the best way to approach this. Keeping in mind that although they both will return results with the same columns, they may or may not have all the same rows. And with that said, I need common rows to add up.
So for example, lets say i use a composite datawindow. And within this i have 2 datawindow children. But now i have the problem of totalling their values, when their rows do not necessarily line up...because one has more rows then the other.
Any hints or tips to go about this would be much appreciated.
Thanks,
I'm not exactly sure the best way to approach this. Keeping in mind that although they both will return results with the same columns, they may or may not have all the same rows. And with that said, I need common rows to add up.
So for example, lets say i use a composite datawindow. And within this i have 2 datawindow children. But now i have the problem of totalling their values, when their rows do not necessarily line up...because one has more rows then the other.
Any hints or tips to go about this would be much appreciated.
Thanks,