0

I have a below datasheet of Employees

enter image description here

I am trying to add PivotTable on the basis of above datasheet enter image description here

We have added Distinct Count of EmpNo and For Variation, we have used Summarize value by Distinct Count of EmpNo and Show Values as "Difference From" with BaseField "JoiningDate" and BaseItem as "(previous)"

For "Variation %", we have used Summarize value by Distinct Count of EmpNo and Show Values as "% Difference From" with BaseField "JoiningDate" and BaseItem as "(previous)"

Problem: In the pivot table's "Variation%" column, we get a blank result if no value for "Distinct Count of EmpNo" was previously present.

Expected Result: If there was no value previously for "Distinct Count of EmpNo" and it is now greater than 0, the pivot table "Variation%" should show 100%.

Can anyone help me on this?

Nachiket
  • 511
  • 5
  • 13

0 Answers0