I Have 4 bar charts ..
1. First Bar chart -> Job Status Code (First dimension value selected) in bar chart - >
In Pivot Table Need to Get SR Number,Job Title,
Job Status Code,Service Type code,Trade Code Person name
2. Bar chart -> Service Type Code second dimension value selected
In Pivot Table Need to Get SR Number,Job Title,
Job Status Code,Service Type code,Trade Code ,Person name
3.Bar chart -> Trade Code 3rd dimension value selected ,then
In Pivot Table Need to Get SR Number,Job Title,
Job Status Code,Service Type code,Trade Code ,Person name
Filtering happening for Job status code but Service type and trade code if i use in the query then i am getting synthetic key issue and circular reference ..
so how to filter pivot table data based on Bar chart dimension selection .. any idea
