Chart expression with field from another table

[denisb]

Hi, 

I have some tables like the blue tables in this picture and I want a table chart like the yellow one. 

Stores is my dimension table and Orders is my fact table. 

To get the total Amount for each store is easy. Just take sum(Amount). 

But I also want to know the sum(Amount) before pp_date and after pp_date for each store. So need, somehow, to pick the right pp_date into my expressions. 

This does not work -> Sum({$<Datum={"<pp_date"}>}Amount) 

You know what I mean? 🙂 Maybe someone has an idea. 

Thanks 

[chrismarlow · Accepted solution]

Hi,

I think you can just use IF statement to do this, like;

Cheers,

Chris.

[denisb]

Thanks.

Yes, of course this works. I tried it before, but it didn´t work. Know I found a mistake in my datamodel/dataset. 

I had some stores with the same data (in my stores table) four times. So my expression made the correct SUM of amount, but four times. 

Crazy 😄