Create Uplift in a pivot table(在透视表中创建提升)-6ren

Create Uplift in a pivot table(在透视表中创建提升)

转载作者：bug小助手更新时间：2023-10-24 20:09:40

I want to create a uplift in excel pivot table using a calculation. Just wondering if there is a way to do this. Could not find a workable solution so far. Here is what I am looking for, =IFERROR(AVERAGE(K3:M3)/AVERAGE(B3:J3)-1,0); column A to S is from the pivot table.

我想使用计算在EXCEL数据透视表中创建一个提升。只是想知道有没有办法做到这一点。到目前为止，还找不到可行的解决方案。这就是我要找的，=IFERROR(Average(K3：M3)/Average(B3：J3)-1，0)；A到S列来自透视表。

For the comment part as follows,
=IF(S3<=5,"-",IF(AND(SUM(G3:L3>5,M3=0),"OK"),"Not OK","OK"))

对于下面的评论部分，=IF(S3<=5，“-”，IF(AND(sum(G3：L3>5，M3=0)，“OK”)，“Not OK”，“OK”))

I want to do the above calculation when there are more rows added or delete some rows without updating the column T & U. Just wanted that to be part of the pivot table

我想在添加更多行时执行上述计算，或者在不更新T&U列的情况下删除一些行。我只想将其作为透视表的一部分

更多回答

I've read your question several times, but I still do not understand what or why you are asking for help.

我已经看过你的问题好几次了，但我仍然不明白你寻求帮助的是什么或为什么。

I want to do the above calculation when there are more rows added or delete some rows without updating the column T & U. Just wanted that to be part of the pivot table.

我想在添加更多行时执行上述计算，或者在不更新T&U列的情况下删除一些行。我只是希望它成为透视表的一部分。

So you copied the pivot table data and paste it here and use that for calculation? That would never update if data would get added. Why are you not adding a calculated column to the pivot table itself? Or if you really want it to update live, you need a formula solution, not pivot table. So please explain yourself further.

因此，您复制了数据透视表数据并将其粘贴到此处，然后将其用于计算？如果添加数据，这将永远不会更新。为什么不将计算列添加到数据透视表本身？或者，如果你真的想让它实时更新，你需要的是公式解决方案，而不是透视表。所以请进一步解释一下。

Yes this is copied data to explain my question (So column A to S is actual pivot table that exist) as I cannot show the actual pivot table due to data privacy. The part I could not do was adding calculated column to pivot table. That was the part I was having trouble with.

是的，这是复制的数据来解释我的问题(所以A列到S是实际存在的透视表)，因为由于数据隐私，我不能显示实际的透视表。我不能做的部分是将计算列添加到数据透视表。这就是我遇到麻烦的地方。

优秀答案推荐

更多回答