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
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.
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
Add a comment