When you use the PivotTable component and you choose the option to calculate totals based on visible items only, you may receive the following error message: The data source does not support totalling only visible items.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help