11-23-2023
01:12 PM
- last edited on
11-24-2023
08:17 AM
by
JackLacava
Hello again, I am creating a pivot grid through a data adapter that works with SQL. The issue I have is that my column of months is not organized in the pivot.
Values example:
Values in the pivot grid:
How can I solve this so that it adapts to how it is organized in the data adapter?
Solved! Go to Solution.
11-23-2023 01:26 PM
Hello,
The simplest way to fix this would be replacing the months format (Jan 2023 => 2023M1) since Alphanumerical Sorting is the default behaviour for pivot tables, but I understand that you want to keep the original format. In that case, you can turn off the Pivot Table's property "Save State" and organise the columns manually.
Another thing to explore might be the BI Viewer's version of Pivot Table, there are more sorting choices there !
All of the propositions above are half-way'ed solutions, there might be a more efficient one
11-23-2023 01:26 PM
Hello,
The simplest way to fix this would be replacing the months format (Jan 2023 => 2023M1) since Alphanumerical Sorting is the default behaviour for pivot tables, but I understand that you want to keep the original format. In that case, you can turn off the Pivot Table's property "Save State" and organise the columns manually.
Another thing to explore might be the BI Viewer's version of Pivot Table, there are more sorting choices there !
All of the propositions above are half-way'ed solutions, there might be a more efficient one
11-23-2023 01:42 PM - edited 11-23-2023 01:51 PM
Thanks, This worked for me 👌