how to put dimensions of a straight table in a drop down list

[#1]

Hi Everyone,

                    I need a straight table with different dimensions put in a drop down list, for example in my project I need Product, Customer and Country as dimensions of a straight table, but I don't want them to be displayed all at once, instead I need them to be put in a drop down menu(like a small icon at corner of the table), so that required dimension can be selected from drop down menu and that particular dimension must be displayed along with other expressions of the straight table. Please help me out if any of you have idea regarding this.

Thanks in advance!

venkysai‌

[florentina_doga]

pls see this exemple

[MindaugasBacius · Accepted solution]

Try this:

If there is no hierarchy I would recommend using Cyclic group.

For Dimensions that are hierarchical use Drill down group.

After creating the Group you will find it in the Dimensions list. Just add it to the Straight table.

[Anonymous]

Hi pfa

[#5]

u may need a pivot ver.

[susovan]

Hi Madhuri,

PFA

You can also try this example,

[#7]

Hello Mindaugas Bacius,

Thanks a lot, it worked exactly how I need.

[MindaugasBacius]

If you find the correct answer could you please close the thread by marking the correct and/or helpful answers.

[#9]

Sure!