5 Replies Latest reply on May 11, 2017 5:53 PM by Zhouyi Zhang

filter -- limit

Kunal Das May 10, 2017 9:17 AM

I have created a filter to show top 10 countries product sales, now at dashboard filter is having following text as well "LIMIT TOP 10 by Sum(sales)"

Can u pls suggest how to remove that text -.-.

1. Re: filter -- limit

Kunal Das May 10, 2017 9:43 PM (in response to Kunal Das)

Can anyone pls suggest ??
Like Show 0 Likes(0)

Actions
2. Re: filter -- limit

Zhouyi Zhang May 10, 2017 9:57 PM (in response to Kunal Das)
Hi, Kunal

alternatively, you can use index instead of putting filter of countries using top n feature.

index as filter sample.twbx 16.5 KB

1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
3. Re: filter -- limit

sesha.peram May 11, 2017 5:53 AM (in response to Kunal Das)

following text as well "LIMIT TOP 10 by Sum(sales)"
Can u pls suggest how to remove that text -.-. This text is referring to the title of filters so we have option called edit title and edit this .
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
4. Re: filter -- limit

Kunal Das May 11, 2017 8:51 AM (in response to Zhouyi Zhang)

Dear Sir , Could you please
let me know,how did you get this index ?

Regards - Kunal
Like Show 0 Likes(0)

Actions
5. Re: filter -- limit

Zhouyi Zhang May 11, 2017 5:53 PM (in response to Kunal Das)

Hi, Kunal

In my sample workbook, there is calculation field called [index] which has the index() function, see below snapshot.

ZZ
Like Show 0 Likes(0)

Actions