Here is what I hate about the default pivot table with two column fields:

■ The outline view is horrible. In Figure 12.10, the value "ABC" appears in the product column only once and is followed by 26 blank cells. This is the worst feature of pivot tables and there is absolutely no way to correct it. Although humans can understand that this entire section is for product ABC, it is radically confusing if your ABC section spills to a second or third page. Page 2 starts without any indication that these customers purchased product ABC. If you intend to repurpose the data, you need the ABC value to be on every row.

0 0

Post a comment