Hi!!! I have one big table with a lot of rows and another table which is a catalog
im making a pivot table with one dimension (so the records get group by that dimension)
and some expresions like this:
count({<TP={VALUE1},TB={VALUE2}>}NOMBRE)
and
count{<TP={VALUE1},TB={VALUE2},RP={VALUE3}>}%IDCAT)
WHERE %IDCAT,TP,TB,NOMBRE ARE FIELDS FROM THE CATALOG TABLE
AND RP,%IDCAT ARE FIELDS FROM THE BIG TABLE
the problem that I have is that when it shows the count of the second expresion is ok
but the first expresion isnt counting rows from the catalog that doesnt have a match in the main or big table
and I need that it also count that rows, any idea so I can get also that rows?
sorry about my English