If you have a table of data, say:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Age[/TD]
[TD]Gender[/TD]
[/TR]
[TR]
[TD]John Smith[/TD]
[TD]45[/TD]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Jane Smith[/TD]
[TD]44[/TD]
[TD]Female[/TD]
[/TR]
</tbody>[/TABLE]
To which you apply an advanced filter which returns cells with Male in the Gender field, is it then possible to assign a name to that filter i.e. return a separate column which will say Men for all rows containing Male?
That would essentially give you mapping for the various filters so that Males would be Men and Females would be Women in this scenario. Is it possible to do that without having that specific mapped column in your source data?
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Age[/TD]
[TD]Gender[/TD]
[/TR]
[TR]
[TD]John Smith[/TD]
[TD]45[/TD]
[TD]Male[/TD]
[/TR]
[TR]
[TD]Jane Smith[/TD]
[TD]44[/TD]
[TD]Female[/TD]
[/TR]
</tbody>[/TABLE]
To which you apply an advanced filter which returns cells with Male in the Gender field, is it then possible to assign a name to that filter i.e. return a separate column which will say Men for all rows containing Male?
That would essentially give you mapping for the various filters so that Males would be Men and Females would be Women in this scenario. Is it possible to do that without having that specific mapped column in your source data?