Extend Pivot Table Data

J

JWSafe

New Member
Joined
Dec 13, 2023
Messages
10
Office Version
  1. 365
Platform
  1. MacOS
Hey, is there any way I can extend the property ref down for each of the types instead of it grouping?
 

Attachments

  • Screenshot 2023-12-19 at 10.20.04 am.png
    Screenshot 2023-12-19 at 10.20.04 am.png
    22.6 KB · Views: 5

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
We can't see your entire layout or know quite how your data is structured and what PT options you have already chosen but with something in the PT selected have a look in the Design ribbon tab at
Report layout -> Repeat All item Labels
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Shortcut to show/hide certain columns?
2
Replies
15
Views
232
Micron
M
C
  • Question
Confused over pivot table calculations :-(
Replies
1
Views
269
number kruncher
N
T
  • Question
Excel Chart, Select Data range, easy method to change how long to show.
Replies
1
Views
253
fourdragons
F
T
  • Solved
Problem with date format when reading from workbook via SQL / ADODB
Replies
7
Views
364
Thebatfink
T
D
  • Question
Conditional formatting on pivot table headers
Replies
0
Views
138
D_SQUARED
D

Forum statistics

Threads
1,215,180
Messages
6,123,504
Members
449,101
Latest member
mgro123

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top