ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Display (https://www.excelbanter.com/excel-discussion-misc-queries/200722-pivot-table-display.html)

Cisco Kid

Pivot Table Display
 
If you have more than one item in the "Row" section of a pivot table the
display only shows the label in the first column once if there is more than
one value in the second item. Is there a way to get the pivot table to
display the value in the first item and not leave blanks? I want to be able
to use the results like a data table.

smartin

Pivot Table Display
 
Cisco Kid wrote:
If you have more than one item in the "Row" section of a pivot table the
display only shows the label in the first column once if there is more than
one value in the second item. Is there a way to get the pivot table to
display the value in the first item and not leave blanks? I want to be able
to use the results like a data table.


Hi Cisco,

I wrote in this group regarding a work-around a few days ago:

http://preview.tinyurl.com/6f3um2


All times are GMT +1. The time now is 07:02 PM.

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