In general queries can be very powerful and can be used to do some fairly complex data manipulation. So I think that what you are proposing may be possible, however this is not a supported feature of the PowerStore so crafting the logic of the records to be stored and the query needed to get the results you are looking for would be a custom endeavor.
This type of feature has been requested frequently by other users here and it is something we are looking into. The more feedback we have from users the better, if you would like to submit any suggestions on this type of feature please make use of our feedback form that is available on the WebAssist site above the top navigation. This type of feedback is extremely valuable to us and will help us to craft better products and meet our users needs. Here is a direct link to the feedback form: