This content has been marked as final. Show 6 replies
Hi,1 person found this helpful
You can achieve this with the union request where you can have different filter for different request.
Thanks for reply. Can you specify the steps to achieve this?
Thanks in advance,
He suggesting something like below1 person found this helpful
SELECT saw_0, saw_1 FROM (
(SELECT Time."Year" saw_0, "#Sales" saw_1 FROM "SA1" WHERE Time."Year" = '2013')
(SELECT "- Open Date"."Open Year" saw_0, "-# Agreements" saw_1 FROM "SA2" WHERE "- Open Date"."Open Year" = '2013')) t1 ORDER BY saw_0
You may use button 'Combine with Similar Request' in criteria tab
If helps mark
Thanks for reply. I'm not sure if you understand me correctly. For example:
I have in a table values X, Y, Z. So i want in the result tab - 3 tables: The first one displays X values, the second displays Y values and the third - Z values. I'm not sure if with your proposal i'll solve the issue. In the result there must be 3 different tables/if we consider my example/. So is it possible to have 3 different WHERE clauses/filters/ associated to the tables:
1. Where <column> = 'X' for the 1st table
2. Where <column> = 'Y' for the 2nd table
3. Where <column> = 'Z' for the 3rd table
Sorry if your solution is correct for the relevant issue.
Thanks in advance,
Using 1 report with 3 different views using 3 different filters I dont think we can do that. I'll keep check for any ones for possible way.1 person found this helpful
For these kind of requirements we got run time filters like Dashboard/Page/report prompts
In other way Instead of filters I would suggest to use Pivot table and pull the column in the sections, that would separate the view based on values... if you compromise with layout Pivot table is the good to go.
Btw: At first instance I was not clear with Table (db table or view as in answers) thats the reason I didnt responded.
Thanks for the help, I think i figured it out. Because in my situation i have a hierarchy table i created some selection steps. It seems good now but it'll be great if there is better solution.