I have a pivot table in which i am showing sum(amount) based on dollar range. According to my requirement i created 4 text objects which will display the dollar range.
Example: Account No: 1234
total amount is split based on physician and employee like 400+100
In my pivot table the 400 and total 500 is showing in color but the 100 is missing . I have attached the app please take a look in sheet 1 and 2. I want the total should be colored.
