Skip to main content

Hi, I have created a simple table report to show activities by Month. 

I want the most recent month to show first. I have a pivot on the Month option to have the table displayed how I want. Am I missing something here? Should I not be able to simply sort by month? This option is not available on the chart:

 

I don’t believe you can order on a pivoted item, @Sarah-Anne .

The documentation comes really close to saying that by stating you cannot rank a pivoted field. Because sorting and ranking are in the same UI area, I would guess that really means you cannot rank nor sort a pivoted field.

https://support.gainsight.com/Gainsight_NXT/Reports_and_Dashboards/User_Guides/06_Advanced_Report_Settings#Apply_Pivot


Reply