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
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 :
SELECT 'Revenue_type',YEAR,REVENUE,0 FROM TABLE WHERE YEAR = 2004
2ND QUERY:
SELECT 'Quantity_type',YEAR,0,QUANTITY FROM TABLE WHERE YEAR = 2005
got it
thank you very much
Instead of 2 diff Queries you can simply use the 'Filter ' function inside the data item and can Get it
for example:
You said
QuoteI 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
Quotequantity only if order year=2005
[/b]
The same thing you can apply here also, this will works out.
Hi,
I can acheived this using the conditional block.
Thanks for all your support
Jahnavi