Skip to main content
Question

Macro with Business Reporter

  • October 25, 2023
  • 2 replies
  • 75 views

Forum|alt.badge.img+10
  • Hero (Customer)
  • 98 replies

Hi ,

Can Macro be used in Business Report. looks like it is not saved when I save the report.

I need to hide a column based on it’s value.

 

Thanks 

2 replies

SandT
Hero (Partner)
Forum|alt.badge.img+6
  • Hero (Partner)
  • 31 replies
  • October 25, 2023

Hi @NMALKI,

 

Please try the steps available in the following article instead of trying macros.

 

https://www.causal.app/excel/hiding-columns-based-on-a-cell-value#:~:text=Hide%20the%20Columns-,In%20the%20%22Format%20Cells%22%20dialog%20box%2C%20go%20to%20the,formula%20evaluates%20to%20%22TRUE.%22

 

I have tried this as above screenshot and it worked for me when company value of cell D7 is 100.

Note: Apply this rule in business reporter design mode and then run the report.


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 98 replies
  • October 30, 2023

@SandT thanks for your reply.

I found this post and apply it as well but it just turn the column values into blank but it doesn’t really hide it .