I have a pivot like this, the column of score is expression
the VbenchBR kinds of things are the variable with a default vaule i have set , my question is how to calculate the sum of total of by the table, it does not work when i have set the partial sum of it
if(RegionFullName='Brazil', [%Regular Students]/VbenchBR, if(RegionFullName='China',[%Regular Students]/VbenchCS,if(RegionFullName='France',[%Regular Students]/VbenchFR,if(RegionFullName='Germany',[%Regular Students]/VbenchGE,if(RegionFullName='Hong Kong',[%Regular Students]/VbenchHK,if(RegionFullName='Italy',[%Regular Students]/VbenchIT,if(RegionFullName='Japan',[%Regular Students]/VbenchJP,if(RegionFullName='Korea',[%Regular Students]/VbenchKR,if(RegionFullName='MEAST',[%Regular Students]/VbenchME,if(RegionFullName='Mexico',[%Regular Students]/VbenchMX,if(RegionFullName='ROA',[%Regular Students]/VbenchROA,if(RegionFullName='ROE',[%Regular Students]/VbenchROLA,if(RegionFullName='ROLA',[%Regular Students]/VbenchROLA,if(RegionFullName='ROW',[%Regular Students]/VbenchROW,if(RegionFullName='Russia',[%Regular Students]/VbenchRU,if(RegionFullName='Spain',[%Regular Students]/VbenchSP,if(RegionFullName='Taiwan',[%Regular Students]/VbenchTW,if(RegionFullName='Thailand',[%Regular Students]/VbenchTH,if(RegionFullName='US',[%Regular Students]
/VbenchUS)))))))))))))))))))
| Code | Name | Region | Score |
| B | Adam | Brazil | 0.7 |
| China | 0 |
| France | 1.1 |
| Germany | 1 |
| Hong Kong | 1.2 |
| Italy | 0.3 |
| Japan | 1.2 |
| Korea | 0 |
| MEAST | 0.1 |
| Mexico | 0 |
| ROA | 0 |
| ROE | 1.3 |
| ROLA | 0 |
| ROW | 0 |
| Russia | 0.2 |
| Spain | 0 |
| Taiwan | 0.4 |
| Thailand | 0 |
| US | 1.3 |
| Total | - |
the total is not there
