Requirement in Straight Table

[priyarane]

Hi Community,

I have requirement like

Show Invest ID where not equal to (Country Jan and Country Dec) or (CCR Jan and CCR Dec)

For the above requirement

1. I have added Invest ID as Dimension and disabled in Presentation

2. I have added expression for Invest ID as if([Country Dec]<>[Country Jan] or [CCR Dec]<>[CCR Jan],INVEST_ID)

3. for Expression - Country Dec: Only({<%Month = {'Dec'}>}COUNTRY_NAME)

4. for Expression - Country Jan: Only({<%Month = {'Jan'}>}COUNTRY_NAME)

5. for Expression - CCR Dec: Only({<%Month = {'Dec'}>}CCR)

6. for Expression - CCR Jan: Only({<%Month = {'Jan'}>}CCR)

7. for Expression - Sale Jan: Sum({<%Month = {'Jan'}>}Sales)

8. for Expression - Sale Dec: Sum({<%Month = {'Dec'}>}Sales)

So Now I got straight table like below:

But users are looking out put only where we have values in Inv ID so they don't wanted to see rest of the data

For ex they wanted to see only highlited ones like below.

How can we achieve this requirement, can some one pls help me. Do I need to changes expressions or any other approach.

[tyagishaila · Accepted solution]

you can try this

if(  [Country Dec]<>[Country Jan] or [CCR Dec]<>[CCR Jan],   INVEST_ID,    0)

add in all expressions except [Inv ID]

if( [Inv ID] = 0, 0,   Only({<%Month = {'Jan'}>}COUNTRY_NAME)   )

....

...

....

....

do it for all expressions.

hope it will work.