Create a drop down list in excel using data from cube

Question

I am currently working on populating the data from the cube on Excel. I am new to Excel. Can anybody suggest me how do we create a drop down list in Excel using the data from the cube as sourse.

I have a product list based on the category like:

Category         Products
---------       ----------
Finance          Audit
                 Contracting
                 Loans
Marketing        Target Market
                 Market segmentation
                 Market subsidies

All the data in the above table is got from the cube. Can we use cube functions as the source in the data validation - Lists.

Can anybody let me know on the possible ways of doing the above.

Can anybody suggest me on the way to do this. Or is it possible to do this ? — user2919277, Oct 07 '14 at 13:18

score 0 · Accepted Answer · answered Oct 08 '14 at 21:58

0

Select both the Category Field and the Product Field in Excel, then from the toolbar select DATA and then Filter. The filter can be used as a dropdown.

If you are looking for something else, please extend the question as it is very vague.

answered Oct 08 '14 at 21:58

phicon

3,549
5
32
62

Create a drop down list in excel using data from cube

1 Answers1