Microsoft Office Tutorials and References
In Depth Information
An important consideration has to be made about dates for which there is available data
in your model. You can see this if you drill down to data at the day level in the PivotTable.
Before doing that, consider the raw data set we used in this example, shown in Figure 7-54.
As you can see, there are more balances for each month. For example, in January there are
balances for days 8, 15, 22, and 31.
FIguRE 7-54 The raw balance data with more balances for each month.
Note In this example, we always have a balance value for each account, as if we took a snapshot
on a certain date for every account available, even if it has not changed its value since the previous
date. We see in the next section what to do whenever this condition is not true.