display specific data in straight table

[#1]

Hi, is there a way to display specific data in straight table? for example, display only data for site a,b and c out of many different sites? What is the script to put in 'expression'? Thanks.

[jagan]

HI,

Try like this, in expression define set analysis to display only specific values

=Sum({<site={'a', 'b', 'c'}>} MeasureName)

Regards,

jagan.

[#3]

Hi,

Instead of expression, Under Dimension Tab

You can add Calculated dimension like below:

if(Site='a' or Site='b' or Site='c',Site)

Hope it may help.....

[its_anandrjs]

You can achieve this by calculated dimension or SET expression in the expression.

1. By calculated dimension

if(Match(site,'a','b','c'),site)

//And select suppress when value null

2. By SET expression

Sum( {< site = {'a','b','c'} >}Measure)