June 19, 2022
I have an OLAP pivot. In my company Olap can not connect with Power Query, so I need to work with it 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?
July 16, 2010
Welcome to our forum!
You could use CUBE functions to extract just the data you want.