Report Filter in OLAP cubes in Excel

[Ijlal]

Hi all.

This is my first ever post on MrExcel.
So I have a bunch of OLAP cubes in excel which need to be updated regularly. I have a field "Markup Range" in Report Filter which has a lot of values from 0.00 to 99.99. Now I need this Markup Range filtered. I filter out the value "0.00" in some of the tables. When I record a macro for filtering out 0 from Markup Range, I get a whole lot of "AddPageItem" methods (for every value from 0.00 to 99.99) being applied to the Markup Range Field. I want it be done using some other way, one which doesnt take up an entire page of code. I havent had much success with finding stuff on internet about this so any kind of guidance would be hugely appreciated.

Thanks.
Ijlal

 

[Ijlal]

My language might be a little bit ambiguous so I gotta beg your pardon for that. Also, in

for every value from 0.00 to 99.99

, I should have written "for every value from 0.01 to 99.99" because I am filtering out 0.00.