Velg en organisasjon
How to filter the records to show where a particular column/value accounts for half of the total
Publiseringsdato: Apr 28, 2025
Oppgave
How to filter the records in which a specific column accounts for half of the total.
In the example below, the specific column is column "C". The values in column C is equal to or more than the Total.
Trinn
<STEP 1>
1. Connect to Sample Superstore.
2. Drag [Category] to Columns and [State] to Rows.
3. Drag [Quantity] to Text in the Mark.
4. Toolbar > Analytics > Totals > Show Row Grand Totals
<STEP 2>
5. Create a new calculated field as following.
Name : Qty of Office Supplies
Calculation : {FIXED [State] : SUM(IF [Category] = "Office Supplies" THEN [Quantity] END)}
//Able to calculate Quantity of Office Supplies by state.
6. Create a new calculated field as following.
Name : Qty by State
Calculation : {FIXED [State]:SUM([Quantity])}
7. Create a new calculated field as following.
Name : Filter
Calculation : IF [Qty of Office Supplies] >= [Qty by State]/2
THEN TRUE
ELSE FALSE
END
8. Drag [Filter ] to Filter Pane > Check in True
Knowledge-artikkelnummer
001458764
Hjalp denne artikkelen med å løse problemet ditt?
La oss få vite det slik at vi kan forbedre!
