This content has been marked as final. Show 2 replies
We see this behaviour sometimes when using table or pivot table prompts. These are what Presentation Services refers to as 'page edge' elements. I think I may have a solution for you... go to the criteria tab and add a second copy of your year and month columns to the criteria. Add these to your pivot table (main body of table) and set them to 'hidden'. By doing this we ensure Presentation Services has not only these elements at page edge but within the actual view itself. Post back here and let us know how you get on.
Thank you for the reply but unfortunately that made things worse. You see, the month and year are filtered in the analysis ("is prompted"). Now, with the addition of the duplicate columns, the analysis takes forever to load (stuck in "Searching..."). It seems to never finish. I have tried to filter those extra columns as well ("is prompted") but there's no behavior change, the analysis is still searching forever.