Team, I have raw data of individual volume sold on a daily basis. I updated Pivot based on month, volume sold and hc involved. I added a "Calculated Field" as production% based on a formula of volume divided by HC involved. Now the challenge is that, i need the pivot line chart for production% only whereas excel gives the pivot chart for volume, hc and production%. Is there any solution to this.
Month | Volume | HC | Production% |
Aug | 2622 | 285 | 61% |
Sep | 3606 | 271 | 89% |
Oct | 3120 | 257 | 81% |
Nov | 3130 | 256 | 82% |
Dec | 2636 | 249 | 71% |
Jan | 2400 | 228 | 70% |
Feb | 2918 | 223 | 87% |
Mar | 3549 | 215 | 110% |