I have a report with multiple queries, on all of these queries I have the same 10 first column.
When I use a report filter I drag and drop one of the first column of one query but the issue is that this column is not link with the others queries.
So how to use a filter for example with the column 2 which will be applied for all the queries ?
Thank you in adavance for your help.
Solved! Go to Solution.
Can you provide some sample data? This seems like a case where you should either merge all of those tables into a single table or separate out those 10 columns into a separate table.
Proud to be a Datanaut!
Create 10 different Tables (one for each of the 10 common columns in all your queries). Once that is done, create a relationship from the individual queries to the 10 different tables. In your visuals, drag the common columns from the 1o different tables.
@Greg_Deckler I have store an sample in the link below:
@Ashish_MathurI am sorry but I am a beginner so I don't understand your answer, I don't know how to create relationship.
In the screenshot below I have try to explain my request. The column in red are on all of the queries, so I want to be able to filter my report by on of these column
I just send you a sample, actually I have many queries
On all the queries there are at the begining the same column but then the column header and data are different so I can't append them.
WoW, it's look it is working very well but I don't understand how the append method works.
Can you give me an explanation or a support document to get more information ?
Than you very much.