Hello everybody,
I have a report with a crosstab : in column i have the years (up) and the companies (down of the years), in rows i have the saler and the customers and in section i have customer's group:
customer's group (section)
Years (2012 to 2015)
companies (2 companies: A and B)
Salers|Customers net sales (measure)
I have a pb, when for a customer's group i haven't data for the company B, the column with the company B doesn't appear like this :
customer's group (section)
Years
Company A |
Salers|Customers 10000 |
And that's what i want: I want if i haven't data for the company B to appear 0€ on the column
customer's group (section)
Years
Company A | Company B
Salers|Customers 10000 | 0
I hope there are enough informations.
Thanks
Regards