带过滤器的计算列(SUMIFS替代) [英] Calculated Column with filter (SUMIFS alternative)
问题描述
您好,我正在尝试找到一个很好的解决方案,以便通过使用过滤功能在我的表的同一行中获取上个月/年的数量。我想得到的是来自另一条线的计算列中的KPI值,以保留除一个(句点)之外的所有
变量。我想在表格的同一行中获取前一个的值。谁能帮我?在Excel中我会用Sumifs完成它,保持除句点之外的所有变量。谢谢!
Hello, I am trying to find a good solution in order to get in the same line of my table the amount of last month / year by using a filtering function. What I want to get is the value of a KPI in a calculated column coming from another line to keeping all variables except one (period). I want to get the value of the previous in the same line in my table. Can anyone help me? In Excel I would have done it with Sumifs keeping all variables fix except the period. Thanks!
推荐答案
带有PowerPivot和Power Query的Excel 365 Pro Plus(又名Get& Transform)
带有计算列和时间智能公式。
如果您的数据是稍微不同。
http://www.mediafire.com/file/ 9ba2593l508pyz8 / 03_10_19.xlsx / file
http:// www .mediafire.com / file / 95lgqcqgrsfkffk / 03_10_19.pdf / file
这篇关于带过滤器的计算列(SUMIFS替代)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!