Two dynamic dimensions showing only when selection made

[#1]

Hi Everyone,

I have a table I wish to make dynamic.  It is basically an Annual or Monthly trending table.  The annual one only has one dimension (Year) and the monthly one has two (Year, Month).

I want to have a dropdown or selection box where the user selects 'Annual' or 'Monthly' and the table changes automatically.

I have tried my usual solution by creating a table like this (notice the blank on the first line for M_DIM):

ANNUAL_MONTHLY_SELECT:

LOAD * INLINE [

          AM_SELECT, A_DIM, M_DIM

          Annual Trends, T_SALE_YEAR_LST5,

          Monthly Trends, T_SALE_YEAR_LST12, T_SALE_MTH_LST12

];

I then setup the following two calculated dimensions in the straight table:

$(=A_DIM)

$(=M_DIM)

This works well for the Monthly Trends as there are two dimensions.  When I try and select Annual Trends, however, QV crashes *every time*.  I'm assuming this is caused by having a blank for M_DIM for the Annual Trends.

Has anyone set up something similar perhaps a different way or can help me with my way?

Thanks

Gareth

[#2 · Accepted solution]

Hi Gareth,

You can solve this by creating two tables: one for the monthy trends and one for the annual trends; then add a showing condition in each one.

Regards!

[#3]

Hi,

Please see if the attached can help you.

Cheers.

[#4]

Thanks both, very helpful!