Skip to Content

Top 3 Played and max match in cross tab with dates

Hi all,

Kindly help us in getting the solution for the requirement at the earliest.

Please consider the below available details from database and we need to provide the solution for Top 3 played games and maximum matches in cross tab (WEBI Report).

1. We need to display the row for max match value having 1 with days along points in cross tab...

2. Hide the rows that has null values in cross tab for points for the respective games.

3. Need to sum up the values for played column for respective name with Games.

4. Need to find the top 3 played person name from among 5.

Please help us in fixing the solution / requirement ASAP in WEBI report.

Regards

Maya

Names.JPG (55.5 kB)
total played.JPG (31.1 kB)
top 3.JPG (24.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Aug 16, 2016 at 11:18 AM

    Right click on the Max Match column and filter the values where 1.

    In the Played column copy this formula=NoFilter(Sum([Played]) In ([Name]))

    Use the Rank function to get the top 3 rank.

    V Rank=Rank([Played])

    Apply the filter on V Rank variable to select first 3 values.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 17, 2016 at 04:23 AM

    Hello Maya,

    Please find resolution for below points.

    1. We need to display the row for max match value having 1 with days along points in cross tab...

    Apply Block level filter with Max Match equals to 1

    2. Hide the rows that has null values in cross tab for points for the respective games.

    After applying above filter your null values will be hidden automatically

    3. Need to sum up the values for played column for respective name with Games

    Create a measure [TotalPlayed] =NoFilter(Sum([Played]) In ([Name])) and display in place of Played


    4. Need to find the top 3 played person name from among 5.

    Please apply Ranking per below screen shot.

    And you will get the O/P as shown below.

    Regards

    Niraj


    Capture.JPG (27.8 kB)
    Capture.JPG (25.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Maya Sivaneswari Mayabalan

      In that case you need to create a variable

      V Rank=Rank([Played]) and use this [V Rank] in the Block Filter along with the existing filter so that if [V Rank]>3 and Values for Days is 0 then only it should hide else will show the record

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.