Hey,
my Data looks like this:
Load*Inline[
Company, attr1,problem_type, contract_with_problem, total_contract
G1, A, N/V, N/V,100
G1,A, Problem1, 10,N/V
G1,A, Problem2, 3,N/V
G1, B, N/V, 100,N/V
G1,B, Problem1, 10,N/V
G1,A, Problem2, 15,N/V
];
and so on.
Now i want to calculate the percentage of how many contracts have a problem (contract_with_problem/total_contract) and still be able to filter through the different Problem types.
My Problem is, that the two measures cannot be put into one, total_contract doesn't have any problem_types and even if i use sum(total total_contract) and filter over the problem_type the sum of total_contract is 0.
Does anybody have an idea how to solve this problem?
Thank you in advance!!!
