If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

2 companies in crosstab but one company appears

Started by Virgin, 24 Mar 2015 11:29:41 AM

Previous topic - Next topic

Virgin

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