Pivot Table Widget Sorting

0
Hello All, I am using the latest Pivot Table Widget. Is it possible to sort the data by the value of the attribute inside the cell? Right now it is sorting by the number on the left Y axis, and not the value inside the cell. Thanks!
asked
1 answers
0

The general idea of the pivot table is that the x and y axis values stay the same while the cell values may differ, for example while applying filters. The widget does have a separate ID and label value for each axis, so you could set the label value to 1 thru 5 and the ID value to anything you like. As long as it is unique!!! If your cell value is not unique, make it unique for example by concatenating it with the axis value:

500-1

500-2

7000-5

 

BTW Be sure to use the Pivot Table Web widget as the other one is deprecated.

answered