Hi All,
Not sure if this can be done but i have a full data set pulled through from SQL PQ, and then the data is sorted in a PivotTable.
However, some of the results are negative values and when i transform the PT into a graph it makes it looks messy.
Is there anyway of making negative values a 0 in a PTable without changing the dataset?
See images.
Bookmarks