Pivot Grid showing incorrect chart column
I'm running into a weird issue where in pivot grid chart is not charting correct columns, below is the example:
I have two columns total amt and ytd amt, pivot grid charts incorrectly by charting YTD Budget into Total Amt and Totoal Amt into YTD Budget, it show corrects columns and data in the grid but incorrect values in the chart by shifting columns.