ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   pivot drilldown (https://www.excelbanter.com/excel-discussion-misc-queries/45012-pivot-drilldown.html)

BorisS

pivot drilldown
 
I thought at one time I was making pivots where I had the ability to drill
down just on one grouping without affecting other groupings. The problem now
is that as I drill down it opens up other groups' occurrences of the item I
am drilling down on.

So I have

Field 1 Field 2 Field 3 Field 4
City Internal
City External
Country Internal
Country External

I would like to drill into just City Internal, but as I do it, Country
Internal also expands. Is this a setting issue, or am I just not remembering
that it's always been this way?
--
Boris


All times are GMT +1. The time now is 05:48 AM.

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