I am attaching 2 screenshots in this email. The first figure is showing a pivot table, while the second one represents the report table of the same pivot. You can see that org. units are being displayed in different order in both figures. Same is happening when I try to get this data using the Analytic API (the org. unit uids is not following the same order in the array). It is quite confusing because I think that the pivot tables are using directly the Analytic API, so I don´t know if I am missing an option or something. Any ideas?
Please, also note that the categories are being displayed in different order as well.
for PT, the order of the organisation units is respected in selection mode no 1 where you “handpick” them yourself. If you select by level they are ordered alphabetically.
Lars, how does this work for the report table?
···
On Mon, Oct 6, 2014 at 1:07 AM, Jose Garcia Muñoz josemp10@gmail.com wrote:
Hi guys,
I am attaching 2 screenshots in this email. The first figure is showing a pivot table, while the second one represents the report table of the same pivot. You can see that org. units are being displayed in different order in both figures. Same is happening when I try to get this data using the Analytic API (the org. unit uids is not following the same order in the array). It is quite confusing because I think that the pivot tables are using directly the Analytic API, so I don´t know if I am missing an option or something. Any ideas?
Please, also note that the categories are being displayed in different order as well.