Return data with no primary key

[#1]

i have an example here i just like to get the accounts with no ID but contains data.

table1

AccountID	AccountName	Sales	Month
101	James	100	Dec
102	Harden	250	Dec
-	-	350	Dec
104	Durant	200	Dec

What's the best way to show the blank data row.

[sreenivas]

Hi

Do you need to eliminate those Values then use inner or left join

[#3]

No sir, i just need to display the data without accountID.

[sreenivas]

If it is a straight Table there will be a option Properties-->dimensions Tab--> check the Supress When Value is Null

[#5]

I need to display

- - 350 dec

[Miguel_Angel_Baeyens]

Hi,

I'd use something like the following to exclude all fields that have a non blank / null value:

Only({< AccountID -= {"*"} >} Sales)

or

Only({1 - < AccountID = P(AccountID) >} Sales)

And the same set analysis with the Month field.

Hope that helps.

Miguel