Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi a new problem for me
i have a pivot table
dimension: itemID
expression1: sum(ORDERlinemaount)
expression2 sum(invoicesalesbalance)
there are two tables
1table: here are my orders with the salesid and the order date sorted by salesid and itemid
2table here are the invoices with the same salesid but the invoices are not sorted by the itemid only the summary of a salesid
i made a mastercalendar for the invoicedate and the orderdate
how can i realize that when i select in the master invoicedate the values for the invoicedate are independent from the selection of the orderdate (values)
Could please provide the table or data for more clarity on the issue.
If your model is associating wouldn't you need 2 (disconnected from each other) calendars? So simplified;