Dear All,I have a table widget that has 2 dimensions in ROW and 3 calculated metrics in COLUMN.When I export the data in xlsx format it creates combinations of all values of the 2 row dimensions. for example, if the table looks like this:When I export the data, it shows: It creates all combination of Region with Customer and displays the value. The Display setting also has below settings disabled: What am I doing wrong ? Regards,Neha Tank

@Neha TankYou did nothing wrong, it’s just the way table work. Multiple non-metric column/row will automatically get broken-out.Can a Customer got 2 or more Region, vice versa?If this is about record, then use record table.Hope this helps

Hello All,Anyone faced this problem before ?Regards,Neha Tank

Export of Table widget (.xlsx format) with 2 row dimensions resulting in all combination of row values

Export of Table widget (.xlsx format) with 2 row dimensions resulting in all combination of row values | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded