Forum Discussion
Create column filled with measures
It took me some time but I got it to work with the drill down.
But I had to create a seperate table in order to make a relationship between the 2 other tables.
Thank you very much for your help!
Anonymous,
Your requirement is not very clear. Show us a complete example, please.
Sorry, I will try to clarify
I have the following table:
Sales representative | Visited company | type |
Representative A Company A acq
Representative A Company B acq
Representative A Company C contr verl
Representative A Company A ROS
Representative B Company D Klant onderh
Representative B Company E ROS
Representative B Company F ROS
Representative B Company G acq
Representative C Company H Contr Verl
Representative C Company I ROS
etc
A second table:
Sales representative | type | Goal # visits |
Representative A acq 150
Representative A ROS 120
Representative A contr verl 30
Representative A Klant onderh 80
Representative B acq 200
Representative B ROS 150
Representative B contr verl 50
Representative B Klant onderh 100
Representative C acq 80
Representative C ROS 120
Representative C contr verl 130
Representative C Klant onderh 180
The report pages are always shown with a filter on sales representative.
Right now I have created KPI visuals which count the number of visit companies with a filter on ""type".
And at target the "Goal # visits"
However, I still find this unclear because I get a lot of different visuals with number while it is not that important information on the report.
To make it more clear I would like to create a bar chart that shows The actual count of visits against the targeted. Seperated (legend) by type.
I hope this makes it more clear
It took me some time but I got it to work with the drill down.
But I had to create a seperate table in order to make a relationship between the 2 other tables.
Thank you very much for your help!
Anonymous,
Glad to hear that. You may help accept solution. Your contribution is highly appreciated.