Custom sort

[Vikkii]

Hi all, I want to sort a pivot based on the options

Example: I have a data contains 3 columns, State_name, Lives (*integer), Coverage (*Percentage values)

I have to create 3 options
1. Alphabetical
2. High to low - Lives
3. Low to High - Coverage

If I choose any of the options my data should sort based on this, is this possible
Can anyone please help

 

[Skyybot]

I think creating a Standard Table for your data should accomplish this.

 

[Bosquedeguate]

Can you provide a short copy of your data (minisheet) and your current pivot table (another minisheet) using XL2BB?

 

[Bosquedeguate]

I think creating a Standard Table for your data should accomplish this.

Or you can select different sort options for your pivot table.
- click on the down arrow in the left-hand column header
- select more sort options from the menu
- select the pivot table column you want to sort (either Ascending or Descending)

 

[Vikkii]

Hi all, I want to sort a pivot based on the options

Example: I have a data contains 3 columns, State_name, Lives (*integer), Coverage (*Percentage values)

I have to create 3 options
1. Alphabetical
2. High to low - Lives
3. Low to High - Coverage

If I choose any of the options my data should sort based on this, is this possible
Can anyone please help

It is the requirement to create a dropdown containing a list
1. Alphabetical
2. High to low - Lives
3. Low to High - Coverage

Based on what we choose, the table should get sorted