I have an table that we input values and discriptions into and multiple tabs that show different outcomes from the data in pivot tables.
I just came across an issue if the data is a negative number, it will not show up in the pivot tables through the worksheet. But the same discription and a positive value has no issue.
I am fairly new to excel and am having a difficult time figuring out why this is happening!
Any help would be appreciated!
I just came across an issue if the data is a negative number, it will not show up in the pivot tables through the worksheet. But the same discription and a positive value has no issue.
I am fairly new to excel and am having a difficult time figuring out why this is happening!
Any help would be appreciated!