Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've a report with 3 calendars:
Order_date
Delivery_date
Invoice_date
and I've to create a bar graph where a sum for each date:
- for how many goods I've received orders,
- how many goods i've delivered,
- for how many good i've billed.
I've tried to build set analysis using in x axis Order_date and with this syntax:
sum(Order_date={'$(Delivery_date)'}>}product_code)
sum(Order_date={'$(Invoice_date)'}>}product_code)
And it doesn't work. How can I solve my problem? Tks
What you need is a shared calendar. See this discussion: Tutorial - Using Common Date Dimensions and Shared Calendars.
Tks!