Add Data Categories

This happens all the time; you get a set of data and you realize that whatever category is there, is wrong. If it’s regions, than there should be 5 regions instead of 8. If it’s product categories, there’s supposed to be a different grouping. And of course there are 10,000 rows of data that need changing.

Here’s a video showing how to re-categorize the data quickly and easily. It uses a few formulas, and we have videos showing those in detail. Do you have another method you’d use? Share in the comments…

Here is the Windows Media version.

One Response to Add Data Categories

  1. Pingback: How to Create a New Category of Data | Business Intelligence Reporting Community

Comments are closed.