Skip to Content
0
Jun 19, 2020 at 12:49 PM

IBP Templates. Adding cell filling in IBPFormattingSheet with different time periods

479 Views Last edit Jun 19, 2020 at 12:54 PM 3 rev

Hi, Colleagues!

When I add in IBPFormattingSheet filling with any color for a key figure, cells fill with any color for a given period (for exaple, 5 weeks). But then, if I want see data for less time period (for example, 3 weeks), filling for 5 time period remains.

Step 1: Add cells filling with yellow: w05-w09

Step 2: Change time period to w05-w07 (cells filling remains for w05-w09)

Question is, can I do anything for this filling remains only for chosen period (not for the longest period). Now for avoiding this, I can only delete rows or columns with filling or manually change filling of cells without data, but automatically filling don't disappear.

Thanks!

BR, Viktoriia

Attachments

step-1.png (41.0 kB)
step-2.png (43.3 kB)