Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
in one table I have 3 different date fields (each splitted in day / month / year): one for subscription start , one for subscription end and one for invoice date.
In one listbox I want to chose the month e.g. Then my diagrams should show all subscriptions started in this month, all subscriptions end in this month and all invoiced data in this month. Is this possilbe to link these different fields?
It is possible, but not recomandable. You will mess up the data.
I would use a variable to specify the reuested month (or a separate time dimension) and filter the data in the expression: =sum(if( month(StartDate) = vSelectedMonth and month(EndDate) = vSelectedMonth and month(InvoiceDate) = vSelectedMonth, Value)
Yes the data will mess up
So I have made two reports for the moment.