I attach an excel file. In the Excel, there is a dataset in sheet1 and a pivot table to summerize the data. In the pivot table, a new field call LR was calculated by using two fields in the pivot table. A chart in "Chart1" tab is linked to pivot and show two fields in the pivot (one of them is calculated field, LR), and have some filters on the top.
My question is why the Axis value in right side of the chart (for the calculated field, LR) will disappear when I click any of the filters? Is there any way it will not disappear?