Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSAS Excel help needed Expand / Collapse
Author
Message
Posted Saturday, July 26, 2014 3:32 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, August 24, 2014 6:58 AM
Points: 61, Visits: 280
Hi guys,

Apologies but I am a total noob when it comes to SSAS. I have literally picked it up today, but have definitely gotten further than I thought I would. I was wondering in a pivot table in excel, say if I have a date dimension table, can I add say the month to the columns without getting a column for every month when viewing the data? I basically want one column named year with what year the row is in, instead of say a column for Jan, Feb, Mar etc.

I don't know if my fundamental understanding of how the pivot table is working is flawed, and what I am trying to achieve is not at all possible, or whether this is a really easy two second fix.

Please if somebody could help me on this one you will make my day!

Additionally, how to I set colors for rows?
Post #1596540
Posted Saturday, July 26, 2014 4:03 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, August 24, 2014 6:58 AM
Points: 61, Visits: 280
Sorry just to clarify this is excel running with a cube as a data source
Post #1596542
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse