How to display the second record in webi report

[former_member1245769]

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.

[manoharsingh · Accepted solution]

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