1 Reply Latest reply on Jan 16, 2019 8:41 PM by Tushar More

    Creating a simple table with dimensions that are subsets of one another

    Charles Blair

      Sorry, I'm not sure how to explain this very well. I'm interested in creating a table that shows certain metrics over varying time periods. Think sales over the past month, over the past 3 months, over the past 12 months etc.This is how I want the table to be structured:

      The problem is that the numbers aren't correct - the months overlap. For example, the previous month is both R1 and R3. I'll attach a workbook with fields to play around with. Feel like this should be simple but I can't figure it out!

       

      Thanks!