Forum Discussion
Actual vs Target
Hello All,
I have below table, I have defined Targets for each product,
for Bike =800, Cloths = 500, Others =1250,
| Product | Sales |
| Bike | 100 |
| Bike | 200 |
| Bike | 300 |
| Bike | 400 |
| Cloths | 50 |
| Cloths | 60 |
| Cloths | 70 |
| Cloths | 80 |
| Others | 250 |
| Others | 300 |
| Others | 350 |
| Others | 400 |
how can I display table something like this ?
| Target | Sales | (Sales\Tar)*100 | |
| Bike | 800 | 1000 | 125 |
| Cloths | 500 | 260 | 52 |
| Others | 1250 | 1600 | 128 |
| Total | 2550 | 2860 | 112 |
Or any other better way to represent ?
NithinBN , Load The target into a table with columns
Product Target
Create a common product table and join both with Product and then you can analyze sales and target together,
Then you have measure like this and display against the Product from the product table
Sales M= sum(Sales[sales])
Target M = Sum(Target[Target])Diff= divide([Sales M],[Target M])
How to create a bridge/common dimension Table
1 Reply
NithinBN , Load The target into a table with columns
Product Target
Create a common product table and join both with Product and then you can analyze sales and target together,
Then you have measure like this and display against the Product from the product table
Sales M= sum(Sales[sales])
Target M = Sum(Target[Target])Diff= divide([Sales M],[Target M])
How to create a bridge/common dimension Table