My report is based on OLAP cube and the requirement is to breakdown the report by Salesperson and also provide a filter selection criteria on SalesPerson. I can drag the salesperson dimension into "Page Layers" or "Context Filter" but not both.
The objective of this report is to provide a filter criteria by salesperson and also breakdown the report by individual salesperson selected by the user .
Is this achievable in RS.
Please advise.
Vincy