I have a pivot chart and a list box as shown below. So from the listbox, if for example I select Portfolio (or Branch, ReturnClass) then in the Chart I only want to see only the PortfolioCode with all the calculations(Number of Records,Completed and e.t.c). It should hide the other two dimensions in the chart i.e. Branch and ReturnClass.