| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTable with Member Property - how to subtotal on Member Proper
I created a Member Property on Time.Day for "WeekOfYear", using the column on
the underlying time dimension table. I was able to expose this Member Property by using the "Property Fields" menu option on the PivotTable menu, so it shows up next to Day. Now, I want to subtotal on WeekOfYear instead of Day or Month. How do I do this in Excel? Is there no way, meaning I should go back and make a second Time dimension (Time2) which goes Year-Week-Day ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Member numbers? | Excel Worksheet Functions | |||
| Cell is a Member of a range or Not | Excel Programming | |||
| Is member of an array? | Excel Programming | |||
| Using Property Let with a Type as member of a Class | Excel Programming | |||
| Is it possible to set a class member to be another class member? | Excel Programming | |||
Hybrid Mode
