Hello
My question is related to an OLAP pivot. In my company Olap can not connect with Power Query, so I need to do this in Excel.
So is this simple pivot table. I need to exclude a list of items from the Products code. There are 3 milions items so I can not have it on rows, only on filtering area. When I select the filter it is showing me a limited number of items, anyway it will be imposible to select 15 items from 3 milions items.
Can you tell me please if is there any posibility to exclude these items without using programming codes like VBA or Python?
Also is there any posibility to include a list of items without using programming codes like VBA or Python?
Thank you
Stelian
Bookmarks