We have a Sense App with a sheet about sales in a shop that shall be used in a story. let's say we have 100 different regions and each region has 50-100 shops.
On the sheet you have a filter for region and shop. So the final report shows one shop only.
This is the twist:
What we want is a story that reacts dynamically to the settings of the region filter.
- select a region
- open the story
- the story must have one sheet per shop. But as the number of shops is different per region, depending on the region, the story must have a different amount of sheets.
- now the region wants to export the story as pdf/ppt to discuss it offline.
You may compare it to a trellis container that uses Shop as dimension to iterate the objects. But with unlimited/dynamic amount of container objects.
How is this possible?
