I am trying to create a pivot. I have chosen 'Date_Wday' for row splits. I have got the respective values for each action, but the respective sum does not add up. I have used column split and selected the Totals to Yes. The count of values is different from the values under All. Kindly help me, what is the logic.