Question

我想利用不同表格的其他栏目制定新的措施,但衡量标准表没有显示其他表格。除在显示措施以外的其他表格时使用总合功能外,

Answer 1

在计算时,你不能仅仅输入表栏,你应当结合公式:

for data column, use formulas such as SUM, AVERAGE, MAX, MIN usually SUM but it depends on your actual needs;
for text column, use SELECTEDVALUE, MAX, MIN;
for date column, use formula related with date such as DATEDADD,DATESBETWEEN, FIRSTDATE, LASTDATE;
if you want to input the table as filter, then use formulas such as FILTER, CALCULATETABLE.