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.
This is actually a dummy data, in actual we need to do sum for expression (Sum(A)/Sum(B) as percentage), is it possible without using the average function in expression?