Forum Discussion
Create Quartiles by Groups and Removing Specific Values
Hi Anonymous ,
I am sorry. I also don't know what Temp_Table and Main_Table are. How to get 0.65 and 0.8. Why the rate data is not the same? Can you provide more detailed data and desired output?
Best Regards
Community Support Team _ polly
AlexisOlson Anonymous
I am sorry, I changed the table names on you:
- Temp_Table = Quartile1 Table. Because I'm summarizing I have to make a summary table and can't do calculated column or measure.
- Main_Table = dataset
The 0.65 and 0.8 are the Quartiles that I calculated manually (I have thousands of rows so this isn't a possibility on my data). For example, In a normal scenario, if I am calculating the first Quartile for the FDR Subclass for Time 12, normally, I would just group everything from 'dataset':
Time Class1 Class2 Subclass1 Subclass2 Vendor SKU Rate 12
1 REF 11 FDR A 111 .089 12 1 REF 11 FDR B 112 .112 12 1 REF 11 FDR C 113 .121 12 1 REF 11 FDR D 121 .080 12 1 REF 11 FDR E 122 .065 12 1 REF 11 FDR F 131 .050 But, for my reasons, I want to calculate the first quartile for Vendor A, but I want to remove Vendor A from the calculation so the 'Rate' that I'm using for this particular grouping is only using the following Vendors (For FDR subclass and Time 12):
Time Class1 Class2 Subclass1 Subclass2 Vendor SKU Rate 12 1 REF 11 FDR B 112 .112 12 1 REF 11 FDR C 113 .121 12 1 REF 11 FDR D 121 .080 12 1 REF 11 FDR E 122 .065 12 1 REF 11 FDR F 131 .050 And the same logic applies for all the other vendors. When I want to calculate the first quartile for vendor B, I want to remove Vendor B's rate from the calculation. And for Vendor C, I want to remove Vendor C's rate from the calculation...etc.