sherifffruitfly
New Member
- Joined
- Dec 21, 2013
- Messages
- 8
Hi all,
I have a pivot table connected to a tabular model. I have row groups going down by calendar granularity: year, month, day. When I click on, say, the February under year 2017, the pivot table expands February for ALL years.
How can I set things up so this behavior doesn't occur? So that when I click to expand February under a specific year, ONLY that years February expands?
I know it can be done somehow, because I've had it with a pivot table against another tabular model a long time ago - I just can't recall how it came to be that way
Thanks for suggestions,
sff
I have a pivot table connected to a tabular model. I have row groups going down by calendar granularity: year, month, day. When I click on, say, the February under year 2017, the pivot table expands February for ALL years.
How can I set things up so this behavior doesn't occur? So that when I click to expand February under a specific year, ONLY that years February expands?
I know it can be done somehow, because I've had it with a pivot table against another tabular model a long time ago - I just can't recall how it came to be that way
Thanks for suggestions,
sff