Rollup a Rollup
Landyn U
I have a scenario where I have layers of data. Each 'host' has multiple 'locations'. Each location has 'sessions'. I am able to rollup all data from sessions at the location level, but now I want to rollup the locations to the 'host' level. However, when I try to select the data, a rollup is not allowed.
In the meantime, I can do this with formulas, but figured this could be helpful for others.
Jon Darbyshire
Hiya Landyn U, thanks for this post! I have a few more questions for you:
- Can you provide more details on the specific data structure or format you are using for the 'host', 'location', and 'session' levels?
- Are there any specific conditions or criteria that need to be met for the rollup to occur at the 'host' level?
- How frequently do you need to perform this rollup, and is it part of a larger workflow or process?