Was reading through my RSS feeds today and read this excelent post by Robert Bruckner which shows you how you can hide a static column and how you can make sure you get the result you want:
One Reply to “Report Design: Shrinking Hidden Static Table Columns”
Is it possible to hide empty columns in a PowerPivot table? I have columns in my table with the year-over-year change.Since the first year does not have a YoY change, I have an empty column. I would like to hide this. I can hide the column in Excel, but that is problematic if I change the number of years displayed. Is there an option to do this in PowerPivot?