Show Report Filter Pages not available if using external data source???

Show Report Filter Pages not available if using external data source???

I created a pivot table based on a connection to a sql server cube

Created a filter

Selected the all and went to options.   clicked on arrow and the show report filter pages is grayed out

Not sure why
johnnyg123Asked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
That's correct. The report filter page feature doesn't work with the pivot table with external source data.
0
 
johnnyg123Author Commented:
Bummer

Thanks for confirmation
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.