Forum Discussion
Pivot table guidance required
HansVogelaar if Target for 5 days is 5000 and achievement is 4500 in 5 days, 500 would remaining Target to achieve. This 500 would be Target for 6th day onwards.
I want pivot table to ignore target for day 6 which is 500, but consider only the achievement of day 5 + Day 6 and provides the result. For Example: if coverage for day 5 is 4500 and for day 6 is 200, so total achievement should be 4700/5000, not 4700/5500.
I hope you understand my question now. I do not want to use VBA as this would increase the file size and I do not have any expertise in PowerQuery or Powerpivot.
I hope that someone else can help you, I don't have the slightest idea. Sorry!
- No issues. You are the first one to respond that is commendable and I am highly thankful for your time to respond. Have a nice day. I wish you all the best.
Detlef_Lewin Below is a glimpse of small data which I need to compile. In the screenshot you can see that after day 5 Target changes, which i do not want pivot to consider while Totaling, Only the target of 5 days and adding up achievement of all days including day 5 and day 6.
I hope it is more clear now. Is there a workaround in pivot table to do this.
