Regarding the display of value

[jahnavi]

Hello friends,

Struck up with a very small doubt

I want to display the Revenue only if order year=2004 and quantity only if order year=2005 in the same list

If am using filter it is showing errors

Can any onbe pls help me in this

[blom0344]

If your rows store both revenue and quantity for a given year, then applying a filter will not work.
Use a union construction (2 queries) and use a third one to display the result, like:

1st query :

Code Select Expand


SELECT 'Revenue_type',YEAR,REVENUE,0 FROM TABLE WHERE YEAR = 2004


2ND QUERY:

Code Select Expand


SELECT 'Quantity_type',YEAR,0,QUANTITY FROM TABLE WHERE YEAR = 2005


[jahnavi]

got it

thank you very much

[Venu_Gollapudi]

Instead of 2 diff Queries you can simply use the 'Filter ' function inside the data item and can Get it

for example:
You said

I want to display the Revenue only if order year=2004

[/b]

here what you can do is, open the data item and edit the exp like
filter([Revenue],[Year]=2004)

and

quantity only if order year=2005

[/b]

The same thing you can apply here also, this will works out.

[jahnavi]

Hi,

I can acheived this using the conditional block.

Thanks for all your support

Jahnavi