how can I make multiple choices in a page field of a pt

slhappyls

New Member
Joined
Sep 17, 2006
Messages
43
I have a pivot table like this:

in page fileds : fruit(apple banana pear peach, ...)
now I want to choose both apple and banana. Can I make a multiple choice in fruit. If not how can I handle this. Because my customer want to make many multiple choices, to create fields of all possible combinations is not possible. Can any one help? Many thanks!


With regards,

Minze
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,541
Members
410,547
Latest member
htran4
Top