Forum Discussion
Summing daily data to monthly data (Automatically)
Does this do what you want?
But If I understand correctly, the pivot table does not adjust automatically when new daily data is added, does it?
Well, that takes on button click, but the totaling happens automatically. And there are manners to make it more dynamic. How crucial really is this automatic (instant) updating? What Excel version are you using, by the way?
You say you get weekly data. I wonder from where, what format. Is it an Excel file, perhaps a csv/txt file?
- It's very crucial that this will update automatically, because it's just one of many customer-Reportings and would take some time. If there was no solution at all, that would be OK but not the optimal solution.
It's used in Google Sheets and the Data comes from the Tool Supermetrics as a Connector for Instagram.LarissaM711 Sorry, but I know noting about GS or Supermetrics. But apparently you get an Excel file out of it and it get's saved in a folder, somewhere on a computer. All automatic?
And you want everything after this to go fully automatic, without any key-press what so ever? Then, I cant help you. Sorry.
The info regarding Supermetrics is not important either, it doesn't matter 🙂
In the end, you can just imagine a normal Excel file, regardless of whether something is automatically pulled in. The only important thing is that the daily data is added bit by bit, and it might be nice to have some kind of reference formula to the monthly sheet that says, for example, that all follower numbers are transferred to month XY if the date/month matches. That's kind of what I had in mind.