Customizing pivot report fields After running a pivot report, you can customize which fields appear and how they are arranged. In a pivot-report, there are four areas where fields can reside: There are two primary methods available for changing the arrangement of your pivot-report. Drag-and-Drop Method You can adjust fields directly from the report’s tab…
“It all depends on how you look at it…” We’ve all heard, and probably used that phrase ourselves many times. It implies that there are many perspectives from which one can look at an issue. Often, the issue is subjective and perhaps even personal. For example, someone who provides something might have one perspective on…
Building pivot tables requires sophisticated Excel spreadsheet skills that most financial experts likely don’t have. While training is available, here is how to engage with a subcontracted expert to develop a pivot table system that truly serves your needs. until you have time for training, this is an excellent way to reduce your time-to-value. There’s…
Anyone who deals with large volumes of data has most likely used grouping to make sense of it. Why? Because grouping data into meaningful buckets can reveal patterns that may not be apparent in a sea of detail. We use groups consciously and unconsciously all the time. We organize ourselves into affinity groups, arrange our…
Download Mercury today. A single-user license is free, and we can help you connect to your own database(s).
