Hide and show data based on list box selection

[#1]

Hi All,

I have a req. like below

E.g. list box  'TYPE' which contains the  values like 'permanent' and 'contract'     

If am selecting 'permanent'

The values in pivot should like this;

EMPLOYEE(DIM)                       expression

emi-id

salary

salary account

If am selecting 'contract'

The values in pivot should like this;

EMPLOYEE(DIM)                      expression

emi-id

salary

salary account

Contract -period

vendor name

vendor location

Thanks in adv,

Ravi

[#2]

Hi

you may use "active condition" in dimension tab according to only(value)='contact'

best regards

Chris

[MK_QSL]

You can use calculated dimension

=IF(GetFieldSelections(Type) = 'Contract', [vendor location])

and below in Enable Condition

GetFieldSelections(Type) = 'Contract'

This will give you Vendor Location if you select Contract in Type.

If you select Permanent in Type the Vendor Location will be dissappeared

[#4]

Thanks for your immediate replies.But no luck !!!

I have to show more than one field data based on selection.

As mentioned in reply  

IF(GetFieldSelections(Type) = 'Contract', [vendor location])

then only vendor location is coming.

e.g. if i select one value in list box ('Contract') it has to show 5 rows in a column and if i select (permanet) it has to show 8 rows.

In both some of them are common and we have to show extra rows when we select the relavent vale in listbox(permanet).

Thanks,

Ravi

[MK_QSL]

This should work else you are doing some mistake.

Can you upload you sample apps.

[#6]

Could plz share the file if you have any already Manish.

[#7]

Need help from some one. If in case any one faced same logic share the app.

Many thanks,

Ravi

[#8]

Hello Raviteja,

Please check out the attached file. As long as the relationship between Type and Employee exist in the way you described then its straight forward.

Let me know if there is something else to it that I might be missing.

Thanks

AJ

[#9]

Thanks AJ...It seems to be match with my logic.Let me go in detail.I will revert if any i req.

Thanks for your time.