0

Pivot table : Download XLSX or Export to Excel related 2 Issues

(1) String/text column used as measure (with min/max) on pivot table. Export to excel doesnt show string as output instead some number come up on that column.

e.g. Table with columns: Rownum, Date, ClientName, Amount; 

add multiple dates and multiple clients per day .. pivot view should be with Date as column and rows has to be records in that Date.

 

(2) Pivot table , with multiple levels/hier on column header.  if we select more than 2 fields on 'pivot table columns' , export to excel fails. Do we have limitation for number of columns to picked on Pivot Columns to make Download XLSX work? However visual on dashboard works fine with multiple columns. 

 

Appreciate quick response. 

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hello Kailas,

    Please could you share the following information regarding the above 2 cases:

    (1) Dashboard export for both cases

    (2) MSExcel version that you're using to view the exported XLSX.

    (3) Incorta version

    Once we have this information, we can troubleshoot further.

    Thank You,

    Divya

    Like
  • Hello Kailas,

    Please let us know if you have any updates on the above issue and if you could provide us with the requested details above.

    Thanks,

    Divya

    Like
Like Follow
  • 5 mths agoLast active
  • 2Replies
  • 32Views
  • 2 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!