Scenario based on common and uncommon dimension value

[shovongoutam]

Dear Community,

I have a large dataset in QVD made from several clculation from >30 tables.

The QVD table looks like the table below.. There are several more segment like segment (columns upto segment 15) and also data column upto data100.

Scenario1	Scenario2	Segment1	....Segment15	Data1	....Data100
High	High	A1		xx
High	Low	A1		xx
Low	High	A1		xx
Low	Low	A1		xx
		A2		xx
		A3		xx
		..		..
		A20		xx

Now i have to make/present graphs for different Scenarios of Scenario1 and Scenario2. 

However, some of the segments' data are do not contain any information in Scenario1 and 2. 

Desired ourtcome would be when I select 'High' in Scenario1, it should also account the empty filed values. Similarly if I select 'Low', it should also account empty fields. So the empty ones should be common for both cases. 

Same for Scenario 2 field, in conjuction with selection of Scenario 1. 

This Scenario choices should be open to app users. 

I look forward to your kind suggestion.

Thank you.

[Sammy_AK]

from the above explanation i understand that you want to display display null values along with selected values? 

[shovongoutam]

Hi,

Yes. So for example for scenario1 if I want to show High...it should take all the High+Null....for Low Low+Null.... So the Nulls should be common in all cases..

[Sammy_AK · Accepted solution]

you can try this logic: 

sum(fld_val) + Sum ({-<fld_1={*}>}fld_val)

sum(fld_val) is the sum which gives you output for selection and Sum ({-<fld_1={*}>}fld_val) this should give you the output for null values. here fild_1 is the field where null values are present, you can improvise this expression by adding the parameters you want. 

[shovongoutam]

Thank you very much. This worked like a charm.