Export of Table widget (.xlsx format) with 2 row dimensions resulting in all combination of row values | XM Community
Skip to main content

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

 

Hello All,

Anyone faced this problem before ?

 

Regards,

Neha Tank

@Neha Tank You 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

I shall try the record table and let you know how it went.

Thanks for the reply.

Leave a Reply


Terms & Conditions