1 Reply Latest reply on Feb 27, 2017 1:56 AM by Vasil Petkov

    Count in a dimension not shown

    michael.wu

      So let's say I have multiple departments, teams, sales people, and individual sales records (represented only by ID). Now, In my chart I want to the total sales count but highlight teams with sales folks that have no sales. Attached is a workbook. As you can see, when I add the dimension for the sales person it shows correctly. When I roll it up to the team, it no longer shows it as having someone without a sale. Sorry if it doesn't seem clear what I'm looking for.