Manually order a text column in a pivot

Comments

9 comments

  • Avatar
    Malinda Jepsen

    Can we do something similar for categories?  I need to order by one field and display another in categories and axis. 

    0
    Comment actions Permalink
  • Avatar
    Nancy Sipley

    This works well -- UNTIL you add the Contribution Quick Function.  Then everything says 100% :(  As many others have said, we really need to be able to determine our own sort order.

    1
    Comment actions Permalink
  • Avatar
    Dabin Hu

    @Arik;

    I can't see the picture in this pages.

    Can you email me the solution?

    Thanks.

    hudabin@commit-info.com

    0
    Comment actions Permalink
  • Avatar
    Dabin Hu

    Can the Bar Chart order by other categories and hide it?

    0
    Comment actions Permalink
  • Avatar
    Kenneth Willingham

    Was anyone able to get the pictures that are missing in the information above?  I have tried going through this with what was provided and haven't been able to make it work.  Or has there been any update in the tool itself with new version releases that will allow me to custom sort my columns in a pivot?

    Thanks

    2
    Comment actions Permalink
  • Avatar
    Jessica Orlando

    Does this script not work if the Pivot Table has columns? Since Columns are a main advantage and use for Pivot Tables, I would hope this could work.

    I copied the script and it removed my sort column from the visual, when I added it back, the field is still present but the values are just missing (instead of the full column disappearing)

     

    1
    Comment actions Permalink
  • Avatar
    An Y

    Hi Jessica 

    If you add the line commented as 'THIS ONE' shown as in  code  below, it will hide the first column 

    $('[id="' + widget.oid+ '"]').find(CUR_COL_FIND_CRITERIA).html("");
    $('[id="' + widget.oid+ '"]').find(CUR_COL_FIND_CRITERIA).css("width", "0px");
    $('[id="' + widget.oid+ '"]').find(CUR_COL_FIND_CRITERIA).css("display", "none"); //<------THIS ONE

     

    AY

    0
    Comment actions Permalink
  • Avatar
    An Y

    Hi 

    I've  found that it works only if  the column you are hiding and sorting  on is the first one in 'Rows' , i.e.  fidx = 0  , and you can not sort on more than one column.

    Could someone else please validate , and offer a workaround - if there is any?

    AY

     
    0
    Comment actions Permalink
  • Avatar
    Dhrubajyoti Das

    I have the pivot configuration as below:

    Since, I want to keep "portfolio" at the last hence I have ranked it only as the highest. I have also added the below script but the rank column is not being hidden.

    widget.on("ready", function(widget, args) {

    var CUR_COL_FIND_CRITERIA = "[fidx=0]";

    //hide current column and set new width for the pivots
    $('[id="' + widget.oid+ '"]').find(CUR_COL_FIND_CRITERIA).html("");
    $('[id="' + widget.oid+ '"]').find(CUR_COL_FIND_CRITERIA).css("width", "0px");
    $('[id="' + widget.oid+ '"]').find(CUR_COL_FIND_CRITERIA).css("display", "none");
    });

     

    Please help

    0
    Comment actions Permalink

Please sign in to leave a comment.