Forum Discussion
Need help adding calculations to pivot chart
Hi Experts, I have hourly data collected from our shared solar system (14 lots). The feed has three phases and it is the analysis of each phase I'm interested in, in particular I want to plot how e...
Hi Riny_van_Eekelen ,
Thanks so much for your effort. But the problem is I need a running CUMULATIVE value. You'll note that the values in your sheet don't match mine.
Note I still appreciate very much the time you put into this.
RedNectar
Ah, didn't see that. Sorry. I believe you need Power Pivot / DAX for that. Though, since you are on a Mac that's not an option. It only works on Excel for Windows. Perhaps someone else has a better idea.