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...
Forum Discussion
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.
Detlef_Lewin here is the attachment
I analysed you formula and rewrote them. Not really something for a pivot table.
But I think that is not what you want.
