E29801192303068A00018344 /* XCRemoteSwiftPackageReference "ProjectDependency" */ = {
isa = XCRemoteSwiftPackageReference;
repositoryURL = "https://github.com/company-uk/ProjectDependency.git";
requirement = {
branch = "debug";
kind = branch;
};
};
基本上只是在计算我每个月有多少订单。
在 B3 单元格中使用它：
=ARRAYFORMULA(IFNA(VLOOKUP(A3:A,QUERY({importorders!A2:C,EOMONTH(importorders!H2:H,-1)+1},"select Col4,count(Col1)
where Col3 = 'Thailand Tour'
and Col4 is not null
group by Col4
label count(Col1)''",0),2,0))
尝试
=query(A2:H,"select Year(H),Month(H)+1,C,Count(H) where C is not null and C like 'Thailand%' group by Year(H),C label C'Tour',Year(H)'Year',Month(H)+1'Month'")
应用于枢纽分析表的数据可能会提供更易消化的分析。
报告摘要
