Hello,
I have trouble with the following scenario:
I have a crosstab, which is populated with aggregated values per month.
- Each row represents a different customer (20002849, 20002159, ...)
- Each column is a different month (01, 02, 03, 04, ...)
My problem is that the values in the crosstab are based on open_time (=FormatDatum([INM Open time];"MM")).
When I execute the report, the crosstab is only creating values for existing data.
When I execute this query today, it will only create the columns 01 - 08 and populate the cells.
I would like that the crosstab is always creted for the whole year 01 - 12 and the default value for each cell should be 0.
Any hints are welcome!
Best regards,
Henning
You have to use TimeDim Function to populate the missing periods of year
also make sure to add 0 to your measure value showing in Cross tab that will sum up as 0 to null values.
De-mystifying the TimeDim function
Regards
Niraj
Add a comment