Export Data without Measure - Vizlib Table
We have a requirement where we want to use one of the master measures in the Vizlib Table and should be ignored while exporting the table. Please note the measure is used to set limitation to the dimension (Limitation-->Relative Value).
Though we have two options to hide column but it doesn't fit for our requirement.
Option 1: we set the calculation condition to 0 --> The column is not calculated. Consequence: it is not included in the Excel export file and the dimensions are no longer using the measure for filtering ( under the dimension limitation dropdown)
Option 2: We set the
Visibility condition to 0 --> The column is hidden. Consequence: it
is included in the Excel export file and the dimensions can still use the
"hidden" measure to do the filtering calculation ( under the
dimension limitation dropdown)
Can we get it accommodated please. Measure should be in use for calculation and at the same time while exporting the table the column shouldn't be present in the exported data.