This request is for the "Add Summary Calculation" Option Available in AdHoc View.
Currently, if you create an Adhoc view there is an option to add Summary Calculation to Calculate Sum of the column's records."Add Summary Calculation" Option Calculates summary for each column Properly.
But While using "Hide Duplicate Rows", "Add Summary Calculation" calculates Sum of the Not Only Duplicate Records But Also hidden records.
ideally, If we use the "Hide Duplicate Rows " Option, the Sum should be of only records displayed to the user.