I have two fields:
customer id-starts from 1,2,3 to 10
sales -500,1000,150 to 200
need to create a combine filter with customer id &sales -completed
my requirement is to use this filter as a multivalue search ,as mentioned below :
client needs if they search with customerid;sales or only customer id in the same filter .values should pop(i.e single filter should depends on both (customerid;sales or customerid)).How to achieve this one?
You can not combine the fields if they are different types. In this case, you will want to copy that sales amount field, make the copy a dimension and then use the combined field functionality (select both fields and right click on "Combined Field"). You can then create a filter from this.