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), % Co...
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.
- Thanks for your efforts.
I want the summary in pivot table form. Target should be up to Day 5.
DownTown/Cantt Target for all five days = 8000, achievement is for five days is 6250, so the remaining Target would be 8000 - 6250, which would be Target for day 6 and I want results as
Target = 8000 which is target of 5 days, here target of day 6 should not be considered in the pivot table.
Now if i want achievement of 6 days, where day 6 target is not required, only achievement is required. How can I do it. You still have not shown what the pivot table should look like.
But I guess the only way to solve it would be DAX measures. And that is not my expertise - yet.
- Yes, indeed. I also got the similar idea from other colleagues, also they suggested to use VBA, in both I am 1/10, so not going to have this ease to i will go manual mode. Or try to explain my supervisor that it is not possible simply. By the Thanks for being with me and replying to my every query and being so much patient quite appreciated.
Bundle of Thanks Dear. - Note: VBA is not DAX and DAX is not VBA.
- Yes, indeed. VBA is coding and DEX is used Power-Query and Power-Pivot.