Forum Discussion
how to make relationship between folder data and excel data
Hi,
I Got data from excel sheet and I got some images in my folder. Images folder having a column called name and excel sheet also having the column called name.
I make a relationship between those two but I filter it in my report its not filtering the data.
Can anyone give a solution to this.
Hi,
Thank you for your reply. The data which I used made some different. So i put the correct user name details. Now its working.
6 Replies
One possible cause of behaviour like this is that the relationship was created in the wrong direction. Filters flow from one table to another in the direction of the arrow on the relationship line.
Hi,
Please find the attched relationship I created.
ANC user List mean, I got that data from folder. Those are my images.
External Outbound data I got from Excel sheet.
So which column from which table are you using to group by in your visual and which column from which table are you aggregating?
