Remove Drill-Down for Mountain Bike material by right-clicking on Mountain Bike, select Expand/Collapse, then select Collapse. Or, you can click on the minus sign (-) next to Mountain bike. Dice: restrict all data to first quarter of 2007 (Jan-March of 2007) to obtain the solution shown below. Years 2007 Date (Multiple Items) Distichan Internet Sum of Revenue Balesorg MatGroupText Bikes Studio Berlin Bikes Studio Magdeburg Munich Bike Store Grand Total City bike (CB) 121,456 6 91,512 132.964 E 315,942 6 Kids bike (KA 27.932 6 22.294 6 34.519 6 84 748 6 Mountain bike (MD) 251,079 170,257 242.077 673,012 Racing bike (RB) 233,057 E 161,094 E 246,800 E 541,061 E Trekking bike (TB) 103,489 E 78,876 E 1 18,379 E 298,743 E Grand Total 737.633 530.033 775.639 6 2043.505 Hint: see steps below. - First, add the Date field (dimension) to the Rows area. It should appear after the MatGroup Text field in the Rows area. Look for a date within the PivotTable area. If you do not see a date, click on a plus next to a MatGroup. Then, right-click on any Date within the PivotTable and select Group. Be sure to select both Months and Years, then click OK. Hint: When you right-click on Date, do not click on the dropdown box