Forum Discussion

NidhiMangtani's avatar
NidhiMangtani
Contributor III
3 years ago

Excel Formatting for spreadsheet component having a cube view

Hi All, We have some cube views which dynamically pull columns as per the cycle being planned.  Cycle1 : 4 quarters Cycle2: 3 quarters Cycle3: 6 quarters Cycle4: 5 quarters  These cube vi...
Cube View
Excel Add In
NicoleBruno's avatar
NicoleBruno
Valued Contributor
3 years ago

Hi Nidhi, 

Could you set up separate column templates for each cycle and share them with the row set? They could be set up with a parameter to be dynamically selected based on the time period. 

For example, we have some selectable row sets so we have a parameter set up on the CV sharing: 

And that parameter selects the CV row template based on the user selection: 

In your case, maybe you could base the parameter off your time selection or something similar so it doesn't have to be manually selected.