Articles in this section

See more

Pivot-table conditon help

Avatar
Tammy Stockton
Updated
Follow 

 Hi All,

I am trying to create a pivto table like so...


  pivot-table
    conditions: Name WHERE Type = Release
    rows: 'Delivery Date'    
    columns: 'Feature'
    empty-rows: true
    empty-columns: true
    totals: true

Essentialy this report would display features on the Y axis delivery date on the X axis and the data populated would be the feature Card name with a link back to the card. It seems the pivot-table only rolls up a sum or count. Is this possible?

Thanks 

Comments

1 comment

Sort by Date Votes
  • Avatar
    Huimin Li

    Hi Tammy:


    For pivot-table, the parameter "Conditions" is used to get a set of cards, and then the value used for "Rows" and "Columns" should be properties apply to the cards you get. And, yes, it only rolls up a sum or count. You can find more information about pivot-table here.


    In your scenario, I would like to understand more about the data. What is the relationship between "Release", "Feature" and "Delivery Date" in your project? Can you provide an example of the report you would like to get. With this information, it would be easier for me to check whether pivot-talbe can provide the thing you are looking for, or suggest a better work-around.


    Thank you very much.


    -- Huimin

    0
    Permalink

Please sign in to leave a comment.