i got this in my script:
LOAD [Datum posjete] as [Visitors datum], 1
[Broj posjetitelja], 2
Shop as Shopovi, 3
Mjesec as [Visitors mjesec] 4
(ooxml, embedded labels);
This table has Visit Date (1), number of Visitors (2), in which Shop (3) and in which month(4). All Visitors for all Shops, per Day and month.
The Goal is to see for every shop turnover, number of invoices... AND the number of visitors on that day for this shop.
Table 1 attachment shows my "Table view". The calculated values i get from the table "Linije", "Visitors" is attached to "Shopovi" so that the name of the Shop is the unique key(Maybe already here is an error, i do not know). I Also need an "connection" between Visitors Datum and InvoiceDate(in table Linije), with an Loop, it gives me wrong numbers and the visitors need to be connected to shopovi!
Table 2 attachment shows the table i want it to look like. Now the "problem" is, all the calculated values/figures behind the field "Broj p..." show me the total amount for every shop. That is wrong, i would like that it shows me the values only for that day.
I would appreciate any help on following things:
- How can i connect "InvoiceDate" and "Visitors Datum", at least for the calculations(sum(Lineamount))... so that table 2looks like this, but with rigth figures?
- How has an expression to look like if i need two fields "checked" for the right Value? sum(if(InvoiceDate=Visitors Datum and(if(Shopovi=?,Lineamount)
Thank you very much in advance and i hope somebody can help me.