I have a "New Order" form, in which I designated the "Record Owner" field to be "Owner" instead of "Added User".

See the attachment for some sample records and the Record owner setting screenshot.

The record was added by andrew.raymond and is now owned by lexshan8.

lexshan8's Role is CEO

andrew.raymond's Role is COO, which reports to CEO.

Therefore, the record should NOT be visible to andrew.raymond. In reality, andrew.raymond is able to see the records.

On the other hand, records with Owner=andrew.raymond Added User=lexshan8 are not visible to andrew.raymond.

The two observations lead me to believe that the pivot chart feature is IGNORING the "Record Owner" setting. It's always using Added User as the "Record Owner".

Can the development team confirm that? How can I make the pivot chart to honor my Record Owner setting?