Problem with the number of data when you select a store and when you bring all the data

[geogou1973]

Hello,

I have the following problem.

I bring the 0 stock in a straight chart with the following expression.

sum({<ITEM_ID = {"=sum(STOC) = 0"}>} STOC)

by store and item. If i export all the data for all stores in an excel for example in the store 21 i have 1104 items that have 0 stock. 

If i select from the stores only the 21 and export the data i have 2122 items that have 0 stock that is the correct.

Have anyone an idea why is this happening ?

Is the problem in the expression ?

 Thank you in advance.

I

[geogou1973]

Unfortunately, the results are the same, i have over 18.000 for store 21.

[geogou1973 · Accepted solution]

I found the solution.

I created a flag in the reload script that i of th

LOAD

STORE,

ITEM_ID,

STOC,

if(STOC=0,'Zero','Value') as FLAG

and in the chart i wrote the following expression

sum({<FLAG={'Zero'}>}STOC)

and i have the same number of rows either i select the store or i don't any of store.

Thank you for your time.