Is there a row limit when using the pivot function on the report builder?

  • 2
  • Question
  • Updated 5 months ago
  • Answered
Is there a row limit when using the pivot function on the report builder? As an example, I have built a table with 1000+ rows, one row row per month per customer. However, when I apply a pivot by month, it changes the report to only have 81 rows. Since we have around 700+ customers in Gainsight, I am expecting around 700 rows and not 81.
Photo of Mai Hoang

Mai Hoang

  • 132 Points 100 badge 2x thumb
  • confused

Posted 5 months ago

  • 2
Photo of Venkateswara Reddy Kasireddy

Venkateswara Reddy Kasireddy, Official Rep

  • 2,230 Points 2k badge 2x thumb
Hi Mai,

We don't have any limit a pivoted report. However we pivot a report on the UI. Lets say your report has 1000 rows before applying pivot, each corresponding to a customer, month combination. When you pivot this report on the month column, the number of results would shrink to 1000/12. The pivot happens on the UI on the already presented dataset (its not a serverside action).

Please let me know if you need more information.

Thanks
Venky