Hi all,
from my source data - one of the columns is shown as negative number.
And I pulled it to be in pivot table and change the formatting to be shown as positive.
Now - when I'm using pivot table to do pivot chart. It is still showing as negative number in pivot chart.
What is the way for me to show it as positive number in pivot chart?
trying to avoid adding new field if possible. Thanks.
from my source data - one of the columns is shown as negative number.
And I pulled it to be in pivot table and change the formatting to be shown as positive.
Now - when I'm using pivot table to do pivot chart. It is still showing as negative number in pivot chart.
What is the way for me to show it as positive number in pivot chart?
trying to avoid adding new field if possible. Thanks.