Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
PFA
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.
Hi Bafana,
Try this:
Go to Object properties -> Dimensions Tab ->
For PortfolioCode dimension check off the enable Conditional option and add FilterName='Portfolio'
For Branch dimension check off the enable Conditional option and add FilterName='Branch'
For ReturnClass dimension check off the enable Conditional option and add FilterName='Return Class'
Hope that helps,
Carlos M