2 Replies Latest reply: Dec 24, 2012 1:26 PM by Mn H RSS

    Crosstables gone wild

      I'd like to simplify my data model, to improve performance. I've built a set of cross tables from the same base of data, to account for different kinds of information:

       

      - Costs by year, and by month

      - Volume by year, and by month

       

      The original table was 800K rows, so you can imagine now there are millions of rows, just for the luxury of having crosstables. It's quite sluggish, and I'd like to find ways to streamline more. Pls opine!