Stock versus Sales

[timsaddler]

Hello

I am working on an app which contains sales data by date and current stock figure.

If i select a time frame in which there were no sales , then the stock "disappears".

The enclosed screenshots should show what i mean.

I

I have tried the "Show all values " dimension option , but it doesn't fix the issue.

Does anyone have any other suggestions?

thx

[alexandros17]

It depends on how data are linked; probably you have a table for sales and a table for stock, joined by material and date ...

If this is  the scenario then you have to avoid the join and let data associate freely ... if not so ... let me know

[timsaddler]

The Answer is set analysis !

[timsaddler]

The Answer is set analysis !

[timsaddler]

The answer is set analysis - had a momentary lapse