Skip to main content
Question

Questions about conditional input and aggregated-level input in Pigments

  • December 10, 2025
  • 0 replies
  • 3 views

Forum|alt.badge.img
  • Apprentice Author

Hi everyone,

 

I have two questions regarding input configuration in Pigments.

 

1. Conditional input depending on the version


When I enable data input in the metric settings (by checking “Allow overriding formula result with an input”), the input becomes available for all cells.

However, I would like to enable input only for specific periods depending on the selected version.
For example, for the Forecast Q2 version, the cells should be editable only from Q2, while Q1 should remain read-only because it contains actuals.


Is there a way to restrict input to specific periods depending on the version?

 

2. Input at an aggregated level

I’ve noticed that when I select data at an aggregated level (for example, “All countries”), input is automatically disabled and the cells become read-only, which is expected. However, from my experience, some clients could request the ability to enter data at the aggregated level.


Is there any possibility to enable input at aggregated levels, or is this not supported in Pigments?

 

Thanks a lot for your help!

 

Best regards,