Custom Report - Ability to Hide/Unhide Columns
Currently we create a budget for each tracking category (department).
I have created a custom report which includes the budget for each category. I then use the formula function to sum the budgets together.
I only want to see the formula column in the report outputted. (I realise that columns can be hidden when data is exported to Excel)
I understand that there is not a way to show a formula column without all the individual budget columns.
Enhancement suggestion: include a radio button for each column to hide/reveal that column in the report
-
Richard Collett commented
This would be really useful, I currently create a full year forecast v original budget column which is:
Full year re forecast budget
- YTD re forecast budget
+ YTD actual
= FYFwhich I then compare to original budget with a variance I currently export to excel and hide the 'calculation' columns, but it would be much better to hide the columns in Xero and out put the report directly to pdf and not have to use Excel as an intermediary step.