Skip navigation

1 Reply Latest reply on Mar 8, 2018 12:30 AM by saurabh.c.0

How to reset Rank() after applying table calculation as Filter

enkhbileg ganbat Mar 7, 2018 10:33 PM

I have table similar to below. RankData1 and RankData2 is Rank() function of Data1,Data2 respectively.

Customer	Data1	Data2	RankData1	RankData2
A	10	26	5	4
B	34	44	3	1
C	21	32	4	3
D	45	15	2	5
E	61	8	1	6
F	9	34	6	2

I have been trying to reset RankData2 when Data is filtered by RankData1. Below is what i have. Is there way to reset RankData2

Customer	Data1	Data2	RankData1	RankData2
B	34	44	3	1
D	45	15	2	5
E	61	8	1	6

ranktest.twbx 21.9 KB

1. Re: How to reset Rank() after applying table calculation as Filter

saurabh.c.0 Mar 8, 2018 12:30 AM (in response to enkhbileg ganbat)

Filters on table calculations gets executed at the end of all operations. So i don't think you can rank it after table calc filters.
Like Show 0 Likes(0)

Actions

More Like This