Parameter in Row does not appear if no value

[Bart]

I have a cross tab query below:

Total Open In-Progress
Support A 2 2
Support B 1 1

I have 3 parameters namely "Support A", "Support B" and "Support C".
However "Support C" does not appear because there is no value for "Open" and
"In-Progress" field. But I want to show all my parameters even there is no
value for "Support C"

 

[Danny Lesandrini]

You need to post your SQL, but the solution probably lies in changing
an INNER JOIN to a LEFT JOIN

 

[Bart]

Here is the SQL:
TRANSFORM Val(Nz(Count(Computation.[Ref No]),0)) AS [CountOfRef No]
SELECT Computation.[Owners Group], Count(Computation.[Ref No]) AS [Total Of
Ref No]
FROM Computation
GROUP BY Computation.[Owners Group]
PIVOT Computation.NoOfMonth In ("<1 Month",">1 Month",">2 Months",">3
Months",">4 Months",">5 Months");