Dear All,
I have dataset with different values. Two of the columns are having values from 1-18. The value 1 is important of all and i need its sum. What i need is to sum up all the 1's in pivot table.
Earlier I have been using below formula in dataset table
=IF(AND(A2=1,B2=1),SUM(A2+B2),IF(AND(A2=1,B2>1),1,IF(AND(A2>1,B2=1),1,0)))
and then using this field sum in pivot table but due to some issues my field colleagues were messing in it and i dont want to include this in the table instead direct formula in pivot table.
Now for summing up all the values I need some formula for calculated field.
The data looks like below:
SampleData.png
The Answer that pivot should give me is sum up all 1s and give answer of 11.
Bookmarks