Hey Guys from Klipfolio,

I need Help please, urgently !!! :)

I have a Bar Chart with one „Series“ that contained 2 different Data sources.

And that’s the problem, the result isn’t right because the assignment from the X-Axis is made from 2 different Data sources and Hidden Data

--------------

This is the calculation with the Series:

(This is the Code from Data source: „Transaktion“)

```
IF(@art; = "1", @umsatz;, BLANK())
```

Minus

(This is the Code from Data source: „Transaktion_Details“)

``` 
IF(
AND(@produkt_id; = "500", @preis; > "0"),
@preis;,
BLANK()
)

+

IF(
AND(@produkt_id; = "500", @preis; < "0"),
@preis;,
BLANK()
)

-

IF(
LOOKUP(
@produkt_id;,
@produkt_id;,
AND(
@kategorie_id; != "7", 
@kategorie_id; != "1", 
@kategorie_id; != "4", 
@kategorie_id; != "5", 
@kategorie_id; != "6", 
@kategorie_id; != "10", 
@kategorie_id; != "11", 
@kategorie_id; != "12", 
@kategorie_id; != "14", 
@kategorie_id; != "32", 
@kategorie_id; != "33", 
@kategorie_id; != "49", 
@kategorie_id; != "42", 
@kategorie_id; != "0")
),
@preis;,
BLANK()
)
```

------------

That is my X-Axis,
„@mitarbeiter_nr“ ist from Data_source: „Transaction-details“

(The first code need the same column: „@mitarbeiter_nr“,
but from the Data_source: „Transaktion“,
the Numbers/Names from the Employees are the same.)

``` 
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
@mitarbeiter_nr;,
"1",
"Johannes"
),
"4",
"Uwe"
),
"26",
"Denise"
),
"24",
"Jenny"
),
"28",
"Sonja"
),
"29",
"Vivian"
),
"30",
"Sami"
),
"14",
"Alev"
)
```

Data source: „Transaktion_Details“

Data source: „Transaktion“ pic 1

Data source: „Transaktion“ pic 2

Hidden Data: @created from Data_source: „Transaktion_details“, filtered by Date

I hope you can help me???

Greetings, Johannes