selection in list box

[Anonymous]

Hi Friends,

Below are the two tables

t3:

LOAD * INLINE [

    Year, Country1, Sales

    2010, India, 1000

    2010, Pak, 2000

    2011, US, 3000

    2012, India, 4000

    2014, UK, 5000

    2013, Pak, 6000

];

t4:

LOAD * INLINE [

    Dummuy

    2010

    2011

    2012

    2014

    2013

    India

    Pak

    US

    UK

];

i have created a straight table with t3 and a listbox with t4.

When i select any value from Dummuy then according to that straight table should show up.

For example:

if i select 2010 from dummuy then only year and sales should be shown in straight table

or

if i select india from dummuy then only Country and sales should be shown in straight table.

kindly help me

Thanks in advance

[sunny_talwar · Accepted solution]

Can you check the attached Anusha

[jonathandienst]

I would do the following:

1. Add a type field to your lookup list:

LOAD * INLINE [

    LItem, LType

    2010, Y

    2011, Y

    2012, Y

    2014, Y

    2013, Y

    India, C

    Pak, C

    US, C

    UK, C

];

2. Assuming that Year and Country (Country1?) are dimensions, then use this expression:

=Sum({<Year = P({<LType = {Y}>} LItem)> + <Country1 = P({<LType = {C}>} LItem)>} Sales)

[Anonymous]

ThankYou Sunny