Creating a Spacer Column in a PowerPivot PivotTable
by, 2012-12-10 at 06:02 PM (342801 Views)
I was amused to read Mike Alexander's blog post on Add Column Spacing In A PivotTable this morning, as I did that exact thing yesterday while working through a PowerPivot solution. At least, I did the same thing, but I did it using DAX. And in this case, DAX is even easier to use that the old method, taking one less step.
Keep in mind I'm using Excel 2013 for this, but it should be the same in 2010.
First I created a new Calculated Field (Measure in 2010):
As you can see, I called it "Spacer", and the formula is simply =BLANK()
From there it gets added to the PivotTable and already shows up as blank values. (No longer necessary to make the custom number format that Mike showed us with an old-school PivotTable).
At that point, I just went to one of the fields on the worksheet that said "Spacer", and entered a single space into the cell, just like Mike did. (Unfortunately, you can't name the measure/calculated field with a single space in the setup, or we wouldn't even have to do that!)
End result (with the blank colum selected so you can see it):