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.