Value mismatched withmysql table 
Used Aggregated calc and Virtual calc as measure and normal dimension 

Check report 1 along with other 2 reports 


Note : After applied and removed sort , value matched with mysql table