This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Please read my issue thoroughly. I know there are several posts about removing blanks, and yes, I have read them all. I am not trying to "Show empty cells as...", my issue is with row values, not column values. My pivot table returns the following for my selected data:
| Date | Stockouts | 2% Target | Stockouts w/ Demand |
|---|---|---|---|
| 7/16/2024 | 273 | 167 | 111 |
| 7/19/2024 | 266 | 167 | 121 |
| 7/23/2024 | 273 | 167 | 140 |
| 7/26/2024 | 254 | 167 | 125 |
| 7/30/2024 | 251 | 167 | 120 |
| 8/2/2024 | 256 | 167 | 130 |
| 8/6/2024 | 291 | 167 | 150 |
| 8/9/2024 | 306 | 167 | 161 |
| 8/13/2024 | 310 | 167 | 149 |
| 8/16/2024 | 310 | 167 | 151 |
| (blank) | 167 |
How do I remove that last row where there is no data? Please note that 2% Target column is a calculated measure and only populates since (blank) is a row value. The value of 167 for that row is nowhere in my source data, nor is a column called 2% Target...again, that is a calculated measure and should only apply to rows with actual data. I have scoured my source data without any filters applied and there are no blanks in the Date column. I have even ensured all cells outside my data range are empty and still have this (blank) row after refreshing data. I deleted the pivot and recreated, still no luck. I've tried literally anything I can find on the subject and nothing removes that row.
I know I can uncheck that in the filter, but that will require checking the new date each time the data is updated. I have several other pivot tables using this same dataset and those do not return any (blank) rows.
How can this be resolved?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Measure Calculation:
=CALCULATE(COUNT('Inventory Data'[Material]),FILTER('Inventory Data',AND('Inventory Data'[Total Stock(MTS + MTO + VCI + CCI)]=0,'Inventory Data'[Safety Stock]>0)))
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 79%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
I'd suggest you post the calculation for the measure - that could be the cause.
Upload the file into my dropbox, that's easier:
Microsoft Answers Community Public Request - Dropbox
Andreas.
I can share the file. How do I grant you specifically access through OneDrive?
Believe me, if the PT outputs an empty field, then there is something in your data or setup that is generating this empty entry. In over 30 years I have seen this many times, it has never been a problem in the PT.
This is possible even if the raw data itself does not visually have an empty entry. A simple explanation would be an invalid date (a text) that produces an error during conversion and then appears as an empty entry in the data model.
If you need further help I need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community
Andreas.