 |
(Ben Taylor) Previously I presented methods for grouping and filtering data in reports using a grouping table. I also introduced methods for producing grouped data in a Rolling Window. The Rolling Window method demonstrates how to group data based on a point of reference instead of the static groups contained within the data itself. Sometimes, neither of these methods meet the requirements of your application. Recently I had to put together a rolling window broken down into periods of 10 minutes. This business requirement established a need for me to dynamically determine my grouping values. This is the first of a series of articles demonstrating how to dynamically build and utilize a grouping table. In this article I demonstrate one method to dynamically create a grouping table. Later in this series I will demonstrate other methods for building a grouping table and how to utilize it to pivot the results. |
