on 11-03-2015 4:35 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ramki..
Explain Bit Clearly..
U want to restrict bu not showing the 2nd record?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.