How do you hide various columns on a pivot table with no table

**LagunaTerry** · 12-13-2017, 08:05 AM

Hi

I have a table driven from access, have set the FY, as year and then period, the financial period is from Apr 17 to May 18. This is shown as year 2017 period 4 to year 2018 period 5. I have data populated upto period 11 (November). However I want to show the remaining periods on the pivot year 2017 period 12 to year 2018 period 5 which have no data. When I ask it to show items with no data on the pivot, I get periods 1 to 3 for year 2017. Is there a way to exclude those without hiding the columns. Please see pivot format below.

FY Year Period
2017/18
2017 2018
1 2 3 4 5 6 7 8 9 10 11 12 1 2 3

Thanks

**sandy666** · 12-13-2017, 09:36 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**LagunaTerry** · 12-14-2017, 04:52 AM

Hi Sandy666
Have uploaded example workbook with before and after views

Thanks

**sandy666** · 12-14-2017, 09:57 AM

Originally Posted by sandy666

Make sure there is just enough data to demonstrate your need.

Did you read this?

create dummy data then create pivot table and on AFTER tab show what you want to achieve

**LagunaTerry** · 12-14-2017, 11:33 AM

Workbook now updated as requested, as explained this pivot is normally linked to MS Access, have shown on the before 2 tab, the table that would be linked

Thanks

**sandy666** · 12-14-2017, 11:48 AM

in your BEFORE PT you've FY filter so tick there Select multiple items and next un-tick (blank)

see Before 2 sheet

**sandy666** · 12-14-2017, 02:04 PM

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it already - ignore it.
Thank you.

How do you hide various columns on a pivot table with no table

LinkBack

Thread Tools

Rate This Thread

Display

How do you hide various columns on a pivot table with no table

Re: How do you hide various columns on a pivot table with no table

Re: How do you hide various columns on a pivot table with no table

Re: How do you hide various columns on a pivot table with no table

Re: How do you hide various columns on a pivot table with no table

Re: How do you hide various columns on a pivot table with no table

Re: How do you hide various columns on a pivot table with no table

Thread Information

Users Browsing this Thread

Similar Threads

Hide fields(table columns) from Pivot table Fields

Hide pivot table columns based on date criteria

Hide null value columns in pivot table

Using Macros - info from sheet go into a Pivot Table - how Can I hide the Pivot Table?

Pivot Table - Hide Columns with No Data?

Hide Subtotals in Pivot Table for Certain Columns

[SOLVED] Hide Subtotals in Pivot Table for Certain Columns

Bookmarks

Bookmarks

Posting Permissions