Regarding Total Mode as a average in Straight Table
I need to create a dashboard and show sales and percentage as a expression in straight table. Now for totals, percentage has to be displayed as Total Mode = Average.
The total for percentage is displaying 11.8 as shown in the attached files(also above), however if we calculate manually, the percentage total(average) should be 118/8 = 14.75 but it is showing 11.8 since it is calculating it as 118/10(including products for which expression is null).
Please suggest how correct average can be displayed.