I have a pivot grid with rows of data for each U.S. State and the data area is counting customer orders. The count is sub-divided into columns for each week (YYYYWW format).
Can the grid be configured to sort the rows based on the last (most recent) week number?
In the example I would want to sort descending on the "202636" column.
Based on the screenshot and description, it sounds like you're trying to sort the State and Tax hierarchy based on the values in a specific YearWeek column (202636).
Pivot Grid sorting is currently applied at the field level and follows the hierarchy structure. When multiple fields are present in rows or columns, sorting is performed on the field as a whole rather than on the values from an individual column member. Because of that, sorting State/Tax based solely on the values for YearWeek 202636 is not currently supported.
Could you provide a bit more detail about the desired outcome? If we're misunderstanding the requirement, a screenshot of the expected result would help us better understand what you're trying to achieve
Thanks for looking into this.
I think that you have a clear understanding of the desired outcome.
The goal is to sort the rows based on the most recent week of activity.
Example: Assume that AR had 1,000 orders in week 35, the users still want to see which state was highest in the most recent week...they would expect AZ to be at the top.
