View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jordan Jordan is offline
external usenet poster
 
Posts: 144
Default Hide Middle Levels

I did a "New Database Query" to bring in a cube and I'm trying to figure out
if there is a way to only hide certain levels of the cube. For instance, the
cube has a dimension call "Fiscal Year", which contains the year, quarter,
month, and week number. Is it possible to only show year and week. I've
been able to hide all but week and all but year, but I have not found a way
to hide just the quarter and/or month levels. Any help you could give me
would be much appreciated. Thanks!