kitjosh1050
New Member
- Joined
- Mar 15, 2015
- Messages
- 22
Hello All,
This is my first post so I hope it's a good one. I am very impressed with the intelligent date functionality of Power Pivot. I cannot however, figure out how to do something seemingly simple.
When I add the date as a ROW and use Date Filters, I have all sort of options - Today, Yesterday, Last Month etc.
When I move the date to FILTERS, the only option I have is to select individual dates. I can't even use between! What i want is the ability to filter like above but without displaying the date in the actual pivot.
I know i can use the Timeline, which is also pretty cool, just not for this particular use case.
I bet the answer is obvious, but I can't seem to figure it out.
This is my first post so I hope it's a good one. I am very impressed with the intelligent date functionality of Power Pivot. I cannot however, figure out how to do something seemingly simple.
When I add the date as a ROW and use Date Filters, I have all sort of options - Today, Yesterday, Last Month etc.
When I move the date to FILTERS, the only option I have is to select individual dates. I can't even use between! What i want is the ability to filter like above but without displaying the date in the actual pivot.
I know i can use the Timeline, which is also pretty cool, just not for this particular use case.
I bet the answer is obvious, but I can't seem to figure it out.