score:0
you can't hide the base item when using it in a "show values as..." setting.
you can, however, create a calculated item that calculates the difference from week 1, display that item and hide both week 1 and week 2 items.
in your pivottable, click any item in the week field.
from the pivottable tools ribbon, go to options > fields, items, & sets > calculated item
you'll need to give it a unique name, such as using an underscore or remove the space.
then create the formula for the field. select your weeks field in the fields list. select the week 1 item in the items list and click insert item to add it to your formula. enter the a minus then insert the week 1 items. click save and the new calculated field is added to your pivottable. now you can hide the original week 1 and week 2 and display only the calculated difference between week 2 and week 1
Source: stackoverflow.com
Related Query
- Show values as "Difference From" with a filter value as the "Base Field"?
- How to check if cell value is greater than X, get the difference from those 2 values and add to the next cell in Excel?
- How to get the unique Year value (using Group By) from a table with multiple date values using SQL query in Access
- Is it possible to filter unique values from a column and copy the unique values with the appropriate values from a not adjecent column to a new sheet?
- How can I use an OptionBox to drive the value of a ComboBox with selective values from my worksheet?
- Fill non-contiguous blank cells with the value from the cell above the first blank
- Extracting the collection of unique values from a filter in VBA
- How do I match the month & year value of the date field with string using VBA Macro?
- How to increment values in one column with the reference of value in another column
- How to copy value from a cell in MSExcel into a field in MSWord file with VB Code?
- Copy values from populated cells only to a different sheet, without extra rows after the last populated value
- MS Access compare a value to a table column and return a field from the same row
- Using excel VBA open file based on cell value with path composed on the fly from same value
- updating summary sheet with values from multiple sheets in difference cells
- How to initialize an Array in VBA with the value from an excel cell that contains a square brackets array?
- Copy the row value from A:F where it indicates "This is not a date format" and paste the values in a specific column
- Excel: 2 sheets, populate the matching cells from one sheet with the values from the other
- VBA Macro to filter, copy the specified value from a column and create then paste in a new sheet with that column name
- Edit a field in record(s) selected from a listbox with a value from a combobox
- How to autopopulate the body of an email with values from a table found by using the Worksheet_Change Function
- Query for getting value from another record in same table and filter by difference greater than a gap threshold
- Get header value from range based on lookup value with multiple lookup values
- How to get values with addons = the value without the addons in excel.
- Create a list with values and key and get the max value
- MS.Access - VBA Print Report From Form with 2 filter criteria in the DoCmd.OpenReport [where condition]
- Sum values until a certain value is reached and then start with the next column
- How can I get the last insert value from MySQL database and update a field in Access?
- Compare the value of a Cell in a Column on one sheet with all the values in a column on another sheet. Color the row depending on the result
- Run a VBA code from changing the value of a cell in another spreadsheet with a combo box
- Fill blank cells with the value from next value below the blanks
More Query from same tag
- How to specify current mailbox Sent Items folder when cancelling .PickFolder dialog in Outlook 2016?
- Saving Multiple Embedded OLE objects to target folder using file explorer
- how to create a table in a word 2003 document using VBA
- how to create a dropdown list in multiple excel sheets from data of one sheet
- How to extract the data using FILTER function in excel?
- How do you return an error object from a function in VBA?
- Using Excel VBA to create an XML file
- Insert multiple images at once from a folder to Rows + Filename
- How to reference a subfolder of a shared mailbox?
- Convert logic in a dynamic query from Access VBA to SQL Server view
- Create TextBox for every row in a column
- How to generate new sheet from find result?
- How to concatenate range of cells according to criteria
- Prompt user to select a worksheet
- compare two sheets in same workbook
- VBA_get cell row and column number before change event
- Excel VBA restarting same Subroutine within itself based on VbMsgBoxResult
- How can I convert these inelegant formulae into VBA?
- Excel FInd and Replace Regex Macro
- How to check if another workbook is open?
- Add rows below last row
- Referencing datarange of pivot table with multiple row fields
- Copy cells in column M that start with "xx" and paste them into another sheet
- Excel VBA Hide different columns depending on different cell values in another sheet, in real time
- Sumproduct Status Bar VBA
- Remove line breaks, return carriages, and all leading space in Excel Cell
- how to change the date format of a cell displayed as yyyy/mm/dd hh:mm:ss in VBA
- Copy a variable range from other files to a summary sheet
- Hide/Unhide text block in MS word depending on selection from dropdown list
- Copy Down Formulas to Last Row