Hide the Date column whenever you define a Dates table in PowerPivot

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

There are already several posts in the blogosphere about the need of using a separate Dates table in PowerPivot to make almost any type of analysis. An important step you should make whenever you have a Dates table (almost always, in theory!) is to hide the Date column of the table containing measures in the Pivot Table.



Tags: excel, time


2007-2015 VidasSoft Systems Inc.