Hi All,
i need your help to find out the pivot table extra column working. i want to show value more than ">" 100000 in extra column filed by pivot table. i am using IF statement =if(amount>100000,1,0) in calculated filed formula, its working and show 1 and 0 but when i do any cell reference to show value than its not working. can you tell me how i can use this to show value greater than 100000 in extra column pivot table. i do it manually column M desired result.
file is attached.
Thanks
Bookmarks