ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   PivotTable with Member Property - how to subtotal on Member Proper (https://www.excelbanter.com/excel-programming/365243-pivottable-member-property-how-subtotal-member-proper.html)

Swordsman

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 ?


All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com