我有两个表 ，表A的数据：monthorderidtypeqty1L130111231BZX832L130111232BZC692L130111238BZC893L130111233BAS913L130111237BZC634L130111234BAS744L130111239BAS74表B的数据, 这里的数据只是举例, 实际数据中failtype大概有3000+个：orderidfailtypefailqtyL130111237short15L130111237electronic10L130111233short16L130111234sample19L130111231electronic10L130111232sample17L130111239sample10L130111239sample14L130111238electronic20L130111238sample11L130111233electronic16L130111234lead18这两个表有一对多的关系，可以用orderid关联起来，我需要在一个组件上展示一个比率，计算方法是 SUM(表B的failqty) / SUM(表A的qty)，这个该怎么做？我看了很多FineBI自带的demo，好像都只能用一个表来在组件上分析的如果用自助数据集把这两个表合并起来，A表的数值就会变成多个，数据就不对了最终计算的结果应该是这样的，这是我在excel里面算的：Row LabelsSum of qtySum of failqtyyield_ratioL130111231831012.05%L130111232691724.64%L130111233913235.16%L130111234743750.00%L130111237632539.68%L130111238893134.83%L130111239742432.43%Grand Total54317632.41%yield_ratiofailtypeorderidelectronicleadsampleshortGrand TotalL13011123112.05%12.05%L13011123224.64%24.64%L13011123317.58%17.58%35.16%L13011123424.32%25.68%50.00%L13011123715.87%23.81%39.68%L13011123822.47%12.36%34.83%L13011123932.43%32.43%Grand Total10.31%3.31%13.08%5.71%32.41%
