Question

Macro with Business Reporter

  • 25 October 2023
  • 2 replies
  • 41 views
N
Rank
Userlevel 5
Badge +10

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
Rank
Userlevel 3
Badge +6

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.

Best Regards, SandT
N
Rank
Userlevel 5
Badge +10

@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 .

 

Reply


Terms & ConditionsCookie settings