Hello everyone,
I am trying to do a new pivot tables based on the following:
1) Choose which stream have the highest Volume. Somehow pick the Business stream and discart the Categories
2) For each Number, which is the highest Division and pick the OM Division
3) Then, the highest Unit. In this case, MCM.
If the Categories stream have the highest Volume, then which Category has the hight volume.
In the end, I would like to have 2 pivot tables like that:
- That counts how many diferent IDs I have for each Division or Category