Need help with % and Total Sale

[gauravnarchal]

Hello -  I need help to calculate the True & False % & sale of each product.

Result %

Status	Sale
FALSE	42.55%
TRUE	57.45%
Total	100.00%

Result Sale

Status	Sale
FALSE	205,900.00
TRUE	278,000.00
Total	483,900.00

Data Table 1

Product	Code	Status
Apple	1	FALSE
Mango	2	TRUE
Banana	3	TRUE
Juice	4	TRUE
Grapes	5	FALSE
Melon	6	FALSE
Watermelon	7	TRUE

Data Table 2

Code	Sale
1	250
2	3500
3	4150
4	4800
5	5450
6	6100
7	6750
1	7400
2	8050
3	8700
4	9350
5	10000
6	10650
7	11300
1	11950
2	12600
3	13250
4	13900
5	14550
6	15200
7	15850
1	16500
2	17150
3	17800
4	18450
5	19100
6	19750
7	20400
1	21050
2	21700
3	22350
4	23000
5	23650
6	24300
7	24950

[lbendlin · Accepted solution]

This can be done via implicit measures.

see attached