The Calculated field if used to calculated the difference between 2 fields gives the difference in amount. Is there a way to get the difference in count. The count formula in Calculated field doesn't seem to work. Kindly help
Count will only work with numbers. So select another box where you want your number and use this formula: =count(x:x) This should give the count number then you will need to find the difference. In another box, use =sum(x-x). This should give you your difference.
If this helps you, please rate me. Thanks, Patty
Prepare table having coloumns Client, Premium Amount , Month.
Now take Pivot table of the above table. Take Field 'Month' in Page field and Client in 'Row' field and sum of amount in 'Data field'.
If you refresh the data and select the required month you will get the desired information.
913 views
Usually answered in minutes!
×