Forum Discussion
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), % Coverage. remaining target to be covered after day 5.
I am asked to give daily 'point in time' comparison status separate day wise e.g. day 1 of Jan, Feb and March and day wise comparison separate (cumulative) e.g. day 1,2 Jan, Day 1,2 Feb, Day 1,2 Mar
Issues:
I need to calculate total for each day using pivot table when activity is completed for all 5 days and then remaining target to be achieved in coming days after 5 days, also i need to compare with previous months data. Everything goes fine till day 5 with way around by filtering. Now I am having issue compiling the remaining Target in one pivot. if i am asked to provide details of total achievement including day 5 total and day 6 separate having achievement against target. and there is no target for day 5 onwards, and this is needed on regular basis in a similar pattern. like: if today is 7, then i need to give target achieved up to day 5 and target achievement on day 6 and day 7 as well separately.
P.S. Sometimes, somethings are additionally included in target for the next month as well, only if found during day 6 and day 7.
- No replies. It means people are not reading or they may not have answers. Or they are too busy to even respond or they are ignoring this thread
Your question has had 93 views, so I suspect that those who read it simply do not understand it.
I for one certainly don't...
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.
