"Include new items in manual filter" for Report Filters and OLAP

T

turtlekoala

Board Regular
Joined
Aug 3, 2012
Messages
54
Hi,

I have a cube backed by an SSAS database, and when I have fields in the Report Filter section, the "Include new items in manual filter" option is greyed out. Does anybody know why this is and if there is a way to get it to work? When they are in the Row Filter or Column Filter section, the option is available. Also, when I create a regular pivot table backed by data in my workbook, the option is available. I'm using excel 2010.

Thanks,
TK
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
You must log in or register to reply here.

Similar threads

P
  • Question
"Include new items in manual filter" greyed out when the field is in the filter area of a pivot table
Replies
7
Views
752
RoryA
RoryA
M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
1K
Alex Blakenburg
A
T
  • Question
Slicer disconnects from pivottable when programatically filtering items in pivot fields
Replies
2
Views
760
Telefonstolpe
T
S
  • Question
Pivot table report filters not displaying filter items
Replies
0
Views
272
Sirod
S
B
  • Question
Pivot Table Zeros
Replies
0
Views
740
bethschmidt0726
B

Forum statistics

Threads
1,215,771
Messages
6,126,799
Members
449,337
Latest member
BBV123

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top