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 |
Is that second table is club to first table? and Please let us know your intend with sample qvw..
The 2nd table is extracted from original table by using the vCounter variable (having value 0 to 7 where 0 means all team) in Max number(1 - 100) under presentation tab.
True, That is showing in your original post. But, What you are needed?
The problem is with my grand total whether the value of vCounter is 0 or any other number upto 7, the grand total always shows win 389 lost 206 while it should be varied, lets see the 2nd table the grand total in QV for win is 389 and lost 206 ignoring the selection of vCounter value while if I select top 3 i.e., value of vCounter =3 then grand total should be win 218 and lost 78 which is correct.
The problem is with my grand total whether the value of vCounter is 0 or any other number upto 7, the grand total always shows win 389 lost 206 while it should be varied, lets see the 2nd table the grand total in QV for win is 389 and lost 206 ignoring the selection of vCounter value while if I select top 3 i.e., value of vCounter =3 then grand total should be win 218 and lost 78 which is correct.
What are your expressions? Are you using dimension limits for your second table?
I am guessing, you have done Dimension limits for Top table. Can you share file to test
No I am not using dimension limit, as I have told you that I have used variable with name vCounter with initial value set to 0and in presentation tab you can see the Max Number having value 1 - 100 by default in Max Number, I have used that variable instead of fixed values.
Expression for each of the tables?