cancel
Showing results for 
Search instead for 
Did you mean: 

How to display the second record in webi report

0 Kudos

Hi Friends,

Recently we are facing issue with displaying the 2 nd record in webi report based on the particular code.

    

      CODE                    DATE                   REVENUE

In the above Image 1st column has code we have to display only 2nd record for each coce

like

MJ-11     01-Jan-2014     14554.4

MJ-19     01-jul-2015        8986.4

MJ-31     24-JUN-2015     6916.9  ect

Any one of you please help me on this....

Regards,

Ramki.

Accepted Solutions (1)

Accepted Solutions (1)

manoharsingh
Explorer
0 Kudos

Hello Ramki,

I have a solution for your requirement,  I did used in one of my projects.

For this example to illustrate.  I have a sample report that i created using your example dataset.

I created a variable to show like below:  Running count on Code, Reset the count by every new Code.

Result: Running count gets reset and starts again on every new code.

Final Step:  Put a Block Filter to show only Running Count Equals to 2.

Hope this helps.

Warm Regards,

Manohar Singh

Answers (2)

Answers (2)

Former Member
0 Kudos

All the answers are questions ... mine too: what is the sorting/ordering criteria on the data? What makes a record to be the second, please?

Anyway, you have no chance to filter based on position, as your filter would impact the position ... you have to filter based on a criteria such as :

the oldest, the biggest ...

Former Member
0 Kudos

Ramki..

Explain Bit Clearly..

U want to restrict bu not showing the 2nd record?

0 Kudos

Hi Regina,

I want to display 2nd record for each code means which I have highlighted with yellow colour. And result Table should be like below

MJ-11     01-Jan-2014     14554.4

MJ-19     01-jul-2015        8986.4

MJ-31     24-JUN-2015     6916.9  ect

Thank you.

Regards,

Ramki.

Former Member
0 Kudos

Create a variable called DateRank as:

=Rank([Date];([Date];[Code]);([Code])

Then add a filter on the table where DateRank = 2

former_member45129
Participant
0 Kudos

on what basis you need to take the 2nd record ??

0 Kudos

Hi Mark Prosser,

Good morning...:)

Thank you for your response.I have created the variable as mentioned the above but I am getting #context error.Could you please suggest me on this please.

Thank you,

Regards,

Ramki.

0 Kudos

Hi Selvarasan Subramanian,

Based on the code we want to display the 2 nd record.
Now the above screen shot each code contains 3 records.
Now I am looking forward to dis play the 2nd record only..

Thank you in Advance.

Regards,

Ramki.

former_member199945
Active Contributor
0 Kudos

Hi

In report other than those 3 objects do you have any other objects  ? & Based on code you are telling to display 2nd record  but it won't  not give distinct value . May be based on date u can get one distinct record like max(date ) & min date etc .

Thanks

former_member45129
Participant
0 Kudos

Why you want 2nd recors why not 3rd or 4th ???

What is the reason for you to choose 2nd reason record ??

What is the business requirement behind this ?