Case 922 When i select Expression = E-Mail_List , How to make Table 2 Total display 4 ?

[paulyeo11]

Hi All

When i select Expression = E-Mail_List .

How to make Table 2 Total display 4 ? Now it display wrong value.

Enclosed my QVW

[Kushal_Chawda]

@paulyeo11  change expression to below for table 2

count(distinct $(ColumnDim51))

[paulyeo11]

Hi Sir

Thank you for sharing .

I need to make it dynamic . If user change the selection of Expression from Email to Sales . The table 2 also will change the value on expression.

[Kushal_Chawda · Accepted solution]

@paulyeo11  try below

=pick(Match([Pls select 51st Dim],'E-Mail_List','SALES'),
count(DISTINCT $(ColumnDim51)),sum($(ColumnDim51)))

[paulyeo11]

Thank a lot.