Relating data

[RobbeVL]

Hi all,

I have a question about relating data.

In the screenshot below you'll see the total number per month for all cities together.

Below you'll see a graph with the total number per city per month.

the total number sums up a few different things from differen sources. 1 source I was able to relate to "overall" but this should actually be devided over the 3 cities.

Is there anyway I can do this withour editing my data source ? 

I could just devide it by 3, but then how do I relate to the correct city?

If you need more data or info, let me know!

[Anonymous]

Hi @RobbeVL,

Can you please share some sample data to test?

BTW, if you want divide dynamic count instead the hard code, you can use 'countx' function calculate 'allselected' items.

Regards,

Xiaoxin Sheng

[RobbeVL]

Hi @Anonymous,

Thanks for your reply!

Below you'll find the data source I was talking about before.

The codes refer to a city (ex. 700002 = Antwerp).) But the code 700000 should be for all cities, and split up over all (3) cities.

The next screenshot show's what the codes are relating to.

How could I split up a value under code 70000?

[Anonymous]

Hi @RobbeVL,

>>How could I split up a value under code 70000?

If these records not contains any regular, it is hard to direct split up to specify city value.

You should add condition to check the current code, if it equal to 70000, summary all amount, otherwise use related amount.

Regards,

Xiaoxin Sheng