5 Replies Latest reply on Dec 6, 2017 2:30 PM by Hari Ankem

# Creating a table with various time frames

I'm wondering if anyone would have a suggestion as to how I could achieve a table that looks something like the below where I show scores per store on a specific rating question... having a heck of a time with date functions. Any help appreciated

 STORES May May last year June June last year July July last year Q1 Q1 last year August August last year September September last year October October last year Q2 etc Store 1 93 13 30 24 41 9 85 90 37 16 57 19 20 49 14 35 Store 2 17 39 98 83 30 93 14 7 32 91 97 19 98 21 94 78 Store 3 66 70 14 44 13 83 35 29 48 82 45 31 51 12 16 1 Store 4 83 48 53 60 32 35 23 36 47 52 75 12 4 91 19 76 Store 5 17 66 48 60 72 38 57 73 65 10 82 48 92 81 81 50 Store 6 8 12 54 27 20 46 89 32 65 1 46 55 65 16 47 33 Store 7 58 39 43 15 87 10 41 86 7 53 73 1 4 68 33 24 Store 8 45 46 1 48 49 3 56 84 2 89 39 13 86 18 87 76 Store 9 10 87 89 93 27 46 82 24 84 70 7 57 51 94 81 62 Store 10 24 9 28 20 16 59 35 3 53 56 18 59 13 8 71 80 Store 11 47 71 90 52 100 86 55 53 94 92 99 39 43 69 88 70 Store 12 7 13 47 20 96 30 91 49 76 54 45 75 96 2 54 41 Store 13 56 54 57 61 78 1 73 11 21 7 9 87 25 51 2 1 Store 14 5 90 85 33 6 61 16 67 16 64 50 8 49 91 98 34 Store 15 9 11 71 43 30 12 35 12 16 26 49 1 31 62 67 47 Store 16 13 95 17 79 13 57 20 86 76 86 83 60 78 89 11 81
• ###### 1. Re: Creating a table with various time frames

Let me know if something like this works for you?

If yes, I can provide the solution.

• ###### 2. Re: Creating a table with various time frames

Hello Hari - yes - that would be amazing. Is it done via calculated fields?

• ###### 3. Re: Creating a table with various time frames

No. Created 2 additional data sources for months and quarters and joined them with the data.

And this is how the sheet has been made.

I have attached a 10.2 workbook, and the data file.

Edit: The month name was manually sorted to display in the required order.

• ###### 4. Re: Creating a table with various time frames

Many thanks! Will give that a go and see what happens with my data.

• ###### 5. Re: Creating a table with various time frames

Sure. Let me know how it goes.