Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Adjust targets when slicing/filtering

Hello,   I have a orders table, with info about that order. I also have a Target table, which gives detailed information about the targets. Now I want to create a visual with order period on X-axi...
Need Help
Show and Tell
Tips and Tricks
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

Anonymous ,

 

Desired output:

A visual which gives me the right amount of orders and target, even if I slice or filter.

So, with no filters I want to see total orders en total target:

jan 19: 6 orders, target 12

feb 19: 4 orders, target 11

jan 20: 3 orders, target 15

feb 20: 4 orders, target 18

 

When I filter on Indirect sales:

jan 19: 2 orders, target 8

feb 19: 4 orders, target 5

jan 20: 2 orders, target 10

feb 20: 3 orders, target 12

 

When I filter on Indirect sales and B2C:

jan 19: 1 orders, target 5

feb 19: 4 orders, target 3

jan 20: 2 orders, target 4

feb 20: 2 orders, target 9

Could you clarify more details and the calculation logic of the result?

 

Regards,

Jimmy Tao