This content has been marked as final.
Show 4 replies
-
1. Re: How do I show my top 3 to look like one 'set of string'?
Shinichiro MurakamiDec 26, 2017 3:41 PM (in response to Alysse Mea)
Hi Alysse
I hope I understood your request correctly.
You need to create couple of layers of table calculations.
Now you need to filter 3rd item.
Thanks,
Shin
-
Top3_String.twbx 28.7 KB
-
-
2. Re: How do I show my top 3 to look like one 'set of string'?
Hari Ankem Dec 27, 2017 9:36 AM (in response to Alysse Mea)-
Top 3 String.twbx 13.8 KB
-
-
3. Re: How do I show my top 3 to look like one 'set of string'?
Alysse Mea Dec 27, 2017 12:37 PM (in response to Hari Ankem)Thank you Shin and Hari! Very helpful. I was able to follow your examples but when I added the dates to my sample data, I got lost again.
I attached my sample workbook. My top 3 would be:
But I am getting this:
I think I need to do sum([total]) but I need help again please. Thank you
-
Book3.twbx 17.2 KB
-
-
4. Re: How do I show my top 3 to look like one 'set of string'?
Hari Ankem Dec 27, 2017 1:28 PM (in response to Alysse Mea)OK...since you have multiple records for each reason now, the formula needs to be changed as shown below. Also, please remember that you need to add the Reason filter to context.
-
Book3.twbx 30.1 KB
-