using AND for Chart

  All   I want my chart to only show users who have used Civil 3D and Revit.    So it should not show only purple bars.   It should only show the bars which have 1 or more in purple AND 1 or m...