Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
These are two tables. In first one all teams all included, while in 2nd table top 3 teams w.r.t. highest win are included. My problem is that I am unable to display the grand total of 2nd table as 218 and 78. How can I display the grand total as I have tried under expression tab to how the sum of number of rows only not the expression total but it does not work.
TEAM | WIN | LOST |
Grand Total | 389 | 206 |
PAKISTAN | 50 | 21 |
INDIA | 44 | 32 |
BANGLADESH | 22 | 46 |
SRI LANKA | 55 | 29 |
AUSTRALIA | 77 | 19 |
NEW ZEALAND | 59 | 26 |
SOUTH AFRICA | 82 | 33 |
TEAM | WIN | LOST |
Grand Total | 218 | 78 |
SOUTH AFRICA | 82 | 33 |
AUSTRALIA | 77 | 19 |
NEW ZEALAND | 59 | 26 |
I think you have understood my problem. I also think that problem is with my expression, so here is my expression
for win
sum(team_win)
for lost
sum(team_lost)
Remove the Max value condition from the presentation tab and try this
Sum(Aggr(If(Rank(Sum(team_win)) < Variable, Sum(team_win)), TEAM))
Sum(Aggr(If(Rank(Sum(team_win)) < Variable, Sum(team_LOST)), TEAM))
I am working on the formula you have given, but in the mean time would you please tell me that what could be the formula if I want to COUNT number of teams also not only their win and lost.
May be this
Sum(Aggr(If(Rank(Sum(team_win)) < Variable, 1), TEAM))
The following expression is not producing the desire result, please send me correct for counting not for sum.
Sum(Aggr(If(Rank(Sum(team_win)) < Variable, 1), TEAM))
The following expression is producing the desire result with slight amendment
Sum(Aggr(If(Rank(Sum(team_win)) < Variable, Sum(team_win)), TEAM))
Sum(Aggr(If(Rank(Sum(team_win)) < Variable, Sum(team_LOST)), TEAM))
The following expression is not producing the desire result, please send me correct for counting not for sum.
Sum(Aggr(If(Rank(Sum(team_win)) < Variable, 1), TEAM))
It seems like you ordering me... ... Anyways, unless I know what you are after, I don't think I will be able to help
The following expression is producing the desire result with slight amendment
Sum(Aggr(If(Rank(Sum(team_win)) < Variable, Sum(team_win)), TEAM))
Sum(Aggr(If(Rank(Sum(team_win)) < Variable, Sum(team_LOST)), TEAM))
What amendment did you make? May be future visitors can benefit from it
Instead of < I have used <= and Max Number under presentation has to be used with variable .
Have you found the expression for counting?
I have not... I am not sure what you are looking to do?
I simply want count not sum
Then what is wrong with this?
Sum(Aggr(If(Rank(Sum(team_win)) < Variable, 1), TEAM))
Should give you count