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 each lot within each phase is tracking to a target percentage share as the month progresses.
I've started by creating a pivot table with a calculated column giving the running total of the solar power delivered to each lot over the selected period for the selected phase.
The problem is, I want to see the running totals as a percentage of the total delivered on any given day for the phase.
I've created an illustration to show what I'm trying to achieve - the light green cells are what I'd like to see instead of the running totals given in kWh.
The source file can be found on onedrive https://1drv.ms/x/c/c95331b296c5ed04/IQBuIcCgK-boRJGmS1e3EKnLARVxjCZTHEpusuvwckW_dDc?e=tS7i4i
Some of the more dedicated followers will probably recognise that this is a follow up question to my recent question that was so skilfully answered in super quick time. I'm hoping I'll be able to create a sheet worthy of sharing with other people who are implementing a shared solar system.
[Trivia: I live in NSW Australia, where the government is giving grants to apartment buildings who implement a shared solar system that gives each lot a fair share - where the amount of the allocation is based on the same formula that calculates the strata fees. Larger lots pay more fees and get more solar. My research so far has shown that the sharing system is not quite working as I expected, but I need to make the whole workbook more bulletproof before I share it publicly]
TIA
RedNectar
3 Replies
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.
RedNectarAh, 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.
