I have a Bex Query with data set as week number in columns and Metrics as rows. That is my first data set for a graph.
Now, I need to build a combo box on charactertics "Customer" ? Can I use the same Bex query connection and assign the characteristic and bind that to a fixed set of region in excel. Will that work? I tried and it did not work.
What is the best approach to do this? Does it need to have customer also as data set? That way my results are going to be big and I believe that affect performance.