Display all Values of a Dimension and Expression

[Anonymous]

Hi Everyone,

I have two tables dp and Answer.I need  to display all the options from dp table even if the value is zero from Answer table and i  want to group all the  text values from Answer table  as 'others' .Others is considered as  one option.I am expecting output like below screenshot.

I want to display all the options including others for particular Id.Please find the attached sample data and app.

Thanks in advance

[ieuyar]

I guess, you confused with ID and Id. In your set expression, you needed to set them both.

Please find attached file.

[Anonymous]

Thanks for your response.

Without merging two tables i want to acheive this requirenmnet. Please find the attached sample.

[vinieme12]

You MUST  concatenate them Options and Value1 are two different fields, if you want to show them in a single Dimension then concatenating them with a FLAG field is the best and simplest option

example

LOAD

KEY

Options

Value1

Id

'dp' as FACTTYPE

From XXXXXX

concatenate

LOAD

KEY

Value as Options

ID

'Answer' as FACTTYPE

FROM XXX;

now use the FACTTYPE field in set analysis to distinguish between Dp data and Answer data