I want o compare base price vs transaction price in single chart
My requirement is, need to compare the data like base price vs transactional price.
Data is coming from different tables, I have combined the single table based on key and calculated the base price as a flag wise in script itself. this base price need to show dimension level and transactional data need to show in expression level. Always I have selected the different selection for base and trans year and month.
1. When we select the base related Year or Month then it would be reflected on base price only.
2. if we select the trans related Year or Month then it will effect to trans -data expressions only.
I have created the sample data and tried but it's not working properly, Please assist me on this requirement.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.