[From Wrike] Sorting Pivot Tables in Wrike Analyze

Hello Community!ย 

Itโ€™s Herine the Analytics Subject Matter Expert from Wrike Support ๐Ÿ˜ผ You might remember me from my previous posts on financial fields and custom fields.ย 

Today Iโ€™ll explain the functionality of Pivot widgets and will cover one of the top pivot questions we get in Wrike Support : why doesnโ€™t sorting work?

One of the main topics we get asked about when it comes to Analyze is Sorting. Today, weโ€™ll look at this in more detail so keep reading ๐Ÿ‘‡ย 

Introduction: Pivots and Tables

Letโ€™s get started by looking at widgets. When two widgets look similar, how do you decide which one to use?ย 

In a nutshell, there are only dimensions (rows/categories) in Table widgets. That means itโ€™s not possible to create formulas in Table widgets which is the main distinction between pivots and tables.

Pivots are more flexible and they have three sections: Rows, Values, and Columns.ย 

In contrast to Table widgets, itโ€™s also possible to create formulas in Pivots, thatโ€™s what the โ€œValuesโ€ section is for. The section โ€œColumnโ€ can be used to break down a formula in Values:

Note: Table โ€œColumnsโ€ and Pivot โ€œColumnsโ€ are different things. Table โ€œColumnsโ€ are more similar to โ€œRowsโ€ in Pivots - itโ€™s the only section available in this widget type. Pivot โ€œColumnsโ€ are more similar to โ€œBreak byโ€ in charts and can be applied only to formulas under โ€œValuesโ€. Since formulas return only numeric values, non-numeric data (dates, text, etc.) cannot be broken down by the โ€œColumnโ€ section.

ย 

Why canโ€™t I sort a Pivot widget?

Another exception to Pivot widgets is aggregation. You might have already noticed from my screenshots that the project name โ€œTarkin Initiativeโ€ appeared three times in the Table widget while the Pivot shows it just once and aggregates other rows under it.

If thereโ€™s no aggregation in a widget at all, youโ€™ll be able to sort a Pivot by any column. In my example below, thereโ€™s just one row for each Project Name, no rows are aggregated, and that allows me to sort the widget by Due Date:

However, once I add Project Owner to this widget, there will be three rows grouped for one of the projects, and sorting by Due Date will have no visual result anymore:

It may seem that sorting isnโ€™t working here, but stick with us :) Once something that activates aggregation is added, the system starts viewing every set of columns as a block. When Iโ€™m trying to sort the widget by Due Date, it wonโ€™t sort anything to the left of that column:

There is almost nothing to sort since there is always just one due date, so it looks like sorting isnโ€™t working. This will be easier to show on the column Project Owner. Since it has aggregated rows, I can change their order within their small aggregated block, but not the order of the projects:

Alternatively, if I didnโ€™t need formulas in my widget, I could just use the Table widget type. It has no aggregation, which means all the data is simply duplicated in every row. As a result, I can sort this by any column:

I hope this article gave you clarity on the differences between pivots and tables! Please let us know if you have any questions in the comments below.



Herine Community Team at Wrike Wrike Product Manager Conosci le straordinarie funzionalitร  di Wrike e le best practices

Herine Wrike Team member Conosci le straordinarie funzionalitร  di Wrike e le best practices

9
7 commenti
Spot On Innovative Approach Stellar Advice

Thanks for the information. I have struggled with how sorting works with Pivot tables, so this helps me and our team.

1
Spot On Innovative Approach Stellar Advice

I don't have analyze but it is great to understand how it works and the capabilities.ย 

1
Spot On Innovative Approach Stellar Advice

Great to have insights on how Wrike Analyze & Sorting is set up with pivot tables, thanks for sharing!

1
Spot On Innovative Approach Stellar Advice

Thanks for this. That was reallynecessary to better understand it.

1
Spot On Innovative Approach Stellar Advice

This is very helpful. I've been trying to begin using the pivot tables and analyze features our team has but noticed that I couldn't always sort. We've had some complaints about people thinking they broke the pivot tables. Now we know! Thank you so much!

1
Spot On Innovative Approach Stellar Advice

Thanks for explaining different types of widgets - now I will be more likely to try to use one in Wrike!

1
Spot On Innovative Approach Stellar Advice

We don't have analyze but this gives great insight of the capabilities and added value

1

Folllowing List for Post: [From Wrike] Sorting Pivot Tables in Wrike Analyze
[this list is visible for admins and agents only]

Su
Didnโ€™t find what you were looking for? Write new post