
1. Re: Calculations for Average of Max 4 Week Sales
tian.yang.4 Jan 4, 2019 8:21 PM (in response to morgan.suttich.1)HI Morgan
This is what you want?
i don't get your logic about 15 categories (if you want to rank by profit for each category i need to change the compute using direction)so I just calculate the overall profit.

Book1.twbx 12.6 KB


2. Re: Calculations for Average of Max 4 Week Sales
morgan.suttich.1 Jan 5, 2019 12:21 PM (in response to tian.yang.4) 
3. Re: Calculations for Average of Max 4 Week Sales
tian.yang.4 Jan 5, 2019 10:41 PM (in response to morgan.suttich.1)can you share the workbook?

4. Re: Calculations for Average of Max 4 Week Sales
morgan.suttich.1 Jan 6, 2019 10:17 AM (in response to tian.yang.4)See Attached  I need it to display just a single number so I don't have to display the weeks.

Top X Weeks.twbx 49.2 KB


5. Re: Calculations for Average of Max 4 Week Sales
tian.yang.4 Jan 8, 2019 2:08 AM (in response to morgan.suttich.1)Hi morgan,
I can't figure this out and in my opinion I can only get top X by rank(or index etc..) which is a table calculation and table calculation's calculation order is too low to calculate more. and that might be the reason why here is the same for sum and average.
Maybe another expert has better solution.
ZHOUYI please help.
YT

6. Re: Calculations for Average of Max 4 Week Sales
Zhouyi Zhang Jan 8, 2019 4:53 AM (in response to morgan.suttich.1)Hi, Morgan
The top N is for each department or overall in your case since you mentioned you just need one number?
ZZ

7. Re: Calculations for Average of Max 4 Week Sales
tian.yang.4 Jan 8, 2019 6:11 PM (in response to morgan.suttich.1)Hi
I finally make it happen but a little bit complex.
As I said before, table calculation cannot be used, so I used LOD to distinguish the top 15.
Finally view:
PLEASE SEE ATTACHED WORKBOOK.
If this posts assists in resolving the question, please mark it helpful or as the ' correct answer' if it resolves the question.
YT

Top X Weeks.twbx 63.7 KB
