How to Make ARM Column Set Values Dynamic Based on From/To Period Range?

Hi ​@tharinduweerasooriya90 , in the column set screen we have the offset field to which we can define how the coulmn names should be displayed based in the start & end periods → the calculation for the Period section under the field.

Hope this helps!

Hello ​@tharinduweerasooriya90 ,

I tried, and failed to create a Profit & Loss report for a customer, where users can choose *any* begin/end period.  Visible Formula setting in the Column Set can control whether a column appears, based on the User Input.  Example:  =IIf( Left(@StartPeriod,2) =3, false, true)

Outcome:  In my case, the IIf statement required to consider *any* range of periods the user may enter was too large for the size limit on Visible Formula cell of Column Sets.

We used a 12-months Rolling column design instead, and it satisfied our customer.  You can find a good example of 12 Months Rolling in Acumatica’s Sales Demo tenant. I hope this helps you.

Hi,

I am still thinking about your report and remembered seeing someone else provide a best answer to the same issue.  Please try the suggestion on this post.  Hope this helps you!