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...
Perhaps the attached will help you on your way. Not sure though what kind of graph you want to create from it.
https://onecom5409298.sharepoint.com/:x:/g/IQB3LBjHGkqFQa30PjmmZp1wAdDU-PKiqy4J7JZQ5w83Vxc?e=zjnhLe
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.