{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Hide Macro Demo"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Hide Macro Demo","index":0,"n_rows":29,"n_cols":11,"rows_kept":29}
[{"$nulls":3},{"$f":"IF(D29=0,\"!\",\"\")","v":""},{"$f":"IF(E29=0,\"!\",\"\")","v":""},"","","!","","!",""]
[null,"Directions"]
[null,"1. In the report, select a row that will act as the flag row to determine if the row will be hidden."]
[null,"In this example, row 1 contains a formula, where if the sum of the column values equals 0, then it will flag the column to hide."]
[null,"2. The macro code is visible in \"This Workbook\" after hitting Alt+F11. It is hardcoded to columns A:AA and will hide columns flagged with \"!\" in row 1."]
[null,"Note that if the OSR_ReportComplete name is used, this macro will run automatically after a BI360 Report has been run."]
[]
[null,"You can demonstrate how the macro works by clicking the \"Run Macro\" button below."]
[null,"Reset the hidden rows by clicking the \"Reset\" button."]
[]
[]
[]
[]
[]
[null,"Account",null,"Actual","Budget","Fcst 1","Fcst 2","Fcst 3","Fcst 4","Fcst 5","Fcst 6"]
[null,4000,null,0,1000,950,930,0,1010,0,910]
[null,{"$f":"B16+1","v":4001},null,3000,2500,2475,2450,0,2575,0,2750]
[null,{"$f":"B17+1","v":4002},null,0,0,0,0,0,0,0,0]
[null,4003,null,2000,1900,2014,2033.0000000000002,0,2052,0,1805]
[null,4004,null,100,0,0,0,0,0,0,0]
[null,4005,null,0,0,0,0,0,0,0,0]
[null,4006,null,0,200,192,188,0,220.00000000000003,0,216]
[null,4007,null,0,0,0,0,0,0,0,0]
[null,4008,null,300,1000,960,1030,0,1000,0,920]
[null,4009,null,0,500,485,500,0,550,0,495]
[null,4010,null,200,0,0,0,0,0,0,0]
[null,4011,null,0,100,97,94,0,106,0,110.00000000000001]
[null,4012,null,100,100,98,92,0,109.00000000000001,0,107]
[null,"Total",null,{"$f":"SUM(D16:D28)","v":5700},{"$f":"SUM(E16:E28)","v":7300},7271,7317,0,7622,0,7313]