Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Benedito Almeida
- Order by date
-
Excel Pivot Table - Hide a Column Without Values
Good morning, SkipVought The image I sent you is just an approximation of what I really need. The problem is a little more complex. These data come from an Analysis Services cube. The columns PREÇO BASE and AVG are calculated members of this cube. To calculate them I need the MONTH level of...- Benedito Almeida
- Post #7
- Forum: Microsoft: Office
-
Excel Pivot Table - Hide a Column Without Values
When [DIM CALENDARIO - CRIACAO].[Hierarquia Tempo].[Ano] For this level Excel is showing the correct value. In the image I sent it's the last column (2019 AVG Sample).- Benedito Almeida
- Post #5
- Forum: Microsoft: Office
-
Excel Pivot Table - Hide a Column Without Values
Hello, SkipVought The AVG columns show zero for all the records because I wrote the following MDX expression in my cube: SCOPE ({([DIM CALENDARIO - CRIACAO].[Hierarquia Tempo].[Mes])}, [Measures].[AVG]); THIS = 0; END SCOPE; This is why the columns AVG are showing zero for all rows. Do you...- Benedito Almeida
- Post #3
- Forum: Microsoft: Office
-
Excel Pivot Table - Hide a Column Without Values
Hi, I have a Pivot Table in Excel that access a cube in Microsoft SSAS. This cube has a time dimension with MONTH and YEAR. In the cube some calculated members are evaluated to NULL for the MONTH level of the time dimension. This is half of the solution I need. Now I have to find a way to...- Benedito Almeida
- Thread
- Replies: 9
- Forum: Microsoft: Office
-
SSAS - Hide Some Calculated Members for a Time Dimension Level
Hello My time dimension has MONTH and YEAR levels. There are some calculated members that my customer wants to see only in the YEAR level. But when I load the cube in Excel these calculated members are shown for months too. Is there a way of hiding theses calculated members for MONTH level...- Benedito Almeida
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
