Forum Discussion
SarangManzoorMemon
Mar 07, 2024Copper Contributor
Pivot table guidance required
I have data set arranged as District n=3(G,S,K), Town n=18 (arranged as G=5,S=5,K=8), and Union Council n=176 (arranged as G=40,S=60,K=76) with values as Set Target (numbers), Coverage (number), % Co...
SarangManzoorMemon
Mar 10, 2024Copper Contributor
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.
HansVogelaar
Mar 10, 2024MVP
I hope that someone else can help you, I don't have the slightest idea. Sorry!
- SarangManzoorMemonMar 10, 2024Copper ContributorNo 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_LewinMar 10, 2024Silver Contributor
- SarangManzoorMemonMar 10, 2024Copper Contributor
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.