Excel Formatting for spreadsheet component having a cube view

NidhiMangtani
Contributor III

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 views have column separators, highlighted rows and columns.

Cube views are included inside spreadsheet component which are then embedded inside the dashboards.

ISSUE: Formatting is different for every cycle due to varying number of quarters. We have had to manually update the spreadsheet components for every cycle due to formatting going off.

Would anyone have a dynamic solution for this?

 

Thanks,
Nidhi Mangtani
2 REPLIES 2

NidhiMangtani
Contributor III

@ChristianW @NicolasArgente @ckattookaran , any thoughts here please?

Thanks,
Nidhi Mangtani

NicoleBruno
Valued Contributor

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: 

NicoleBruno_0-1662999717045.png

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

NicoleBruno_1-1662999758797.png

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.