I am trying to split the revenue based on customer grouping. Some how if I see row 4 it has two number side by side instead of falling into same group.
That has to do with the way you're looking at a dimension. Can you post a packaged workbook sample of what you're working on, so the community can precisely see what the issue is, and help explain it?
Retrieving data ...