Change the Default Fields for a Values Table
When you create a values table, particular dataset fields are shown by default. When the fields are sorted in alphabetical order, which includes dates, the table shows the first five measures and first five dimensions. You can change the default fields by editing the XMD.
For example, the explorer shows the following default fields.
To change the default fields, specify the field names, not the labels, in the XMD.
After applying the XMD to the dataset, here’s the values table with the default fields.
See Also