Matrix Report excel file shows all fields data even though all fields are not selected under Display Options of Matrix Report.
SuccessFactors BIZX: Matrix Report v12
Reproducing the Issue
1: Under Succession go to 'Performance-Potential matrix'
2: Select only one field under Display Options of matrix report, as below:
3: Matrix report shows only Gender icon and doesn't show rest of the icons in the report.
4: Click on the Export icon to export matrix report data into excel file and you would find that the exported file shows data of all fields (if it is present) even though those fields are not selected under Display Options
Excel file of matrix report is designed to show data of all fields present in Display Options that means if there are 3 fields (say Risk of Loss, Impact of Loss & Gender) and you have selected only one field (say Gender) under Display Options then also exported excel file will show data of all three fields (Risk of Loss, Impact of Loss & Gender).Display Options of matrix report doesn't control the visibililty of data on excel file, this is the expected behavior.
- Matrix Report excel
- Display Option in excel report