Skip to Content
Author's profile photo Alecsandra Dimofte

How to format based on the time buckets

Hi all,


I would like to share with you some knowledge on how to format specific time buckets.

  1. <relative> property of the time bucket
  • Select required KF & Add to Multiple Selection


  • Go to Property Selection, make your selection and add it to Multiple Selection as well.

Below selection will return the combination between KF and Current Time Bucket + 2 (you can check your selection in Multiple Selection Overview tab)


  • Result:


As current month is July the format is applied to September (July  + 2).


I have tried with other operators (different than ‘=’) but, unfortunately, it didn`t work as expected. To have time range dependent format please check below workaround:


2.  Excel workaround


I started from the requirement of having a yellow fill for Sales Fcst Price in [Current Month, Current Month + 3] time range

  • I added some dummy entries for Current Date+3  and another row to return the Time Bucket Header date in the same format.

H15 points to Current Date + 3  using the following formula =DATE(YEAR(TODAY()), MONTH(TODAY())+3, 1)


  • Then I inserted a Local EPM member DATE with the following calculation: =IF($H$15>H16,1,0)
  • I added Conditional Formatting to Sales Fcst Price so that format to be applied when DATE equals 1


It works also w/o creating local member as below and point the conditional formatting to H18.


This trick could be applied also for locking cells in a specific time horizon.

If you know any other workaround please share!




Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Nice post! This should be useful for many implementations.