From the given table:

Type

No Bedrooms

No Bathrooms

Garden Size

Asking Price

Sale Price

Detached

$4$

$2$

Medium

$345,000$

Semi$-$detached

$3$

$1$

Small

$245,000$

$238,500$

Terraced

$2$

$1$

Small

$199,000$

$199,000$

Detached

$4$

$2$

Large

$398,000$

$387,500$

Semi$-$detached

$3$

$1$

Medium

$329,000$

$319,500$

Detached

$4$

$2$

Large

$478,500$

Terraced

$2$

$1$

Small

$213,000$

$199,500$

Semi$-$detached

$3$

$2$

Medium

$278,500$

$277,000$

Semi$-$detached

$3$

$1$

Large

$278,500$

Terraced

$3$

$2$

Small

$176,500$

$174,300$

Bungalow

$2$

$2$

Medium

$223,750$

$219,750$

Flat

$1$

$1$

None

$135,000$

Terraced

$3$

$1$

Small

$165,900$

$168,000$

Bungalow

$3$

$2$

Large

$415,500$

$419,500$

Bungalow

$3$

$2$

Large

$415,500$

$419,500$

Bungalow

$2$

$2$

Medium

$199,500$

Flat

$2$

$1$

None

$175,500$

$169,500$

Suppose that you want to create the following pivot table:

$???$

Column Labels

Row Labels

$1$

$2$

Grand Total

Bungalow

$4$

$4$

Detached

$3$

$3$

Flat

$2$

$2$

Semi$-$detached

$3$

$1$

$4$

Terraced

$3$

$1$

$4$

Grand Total

$8$

$9$

$17$

Then, you should drag

Blank to the rows,

Blank to the columns and

Blank to the values in the Pivot Table Fields pane.