straight table dimension issue.

[vinay_hg]

Guys,

i have 2 tables, between 2 tables userid is key, imagine for a date period

one user table

userid     geo     username

1          India     raj

2          KSA     gagan

3          UK         meera

4          USA     neel

sales activity table

activityid     userid     desc

1               1               YYYYY

2               3               CCCC

3               3               UUUU

4               3               UUURRR

I WANT RESULT like below

Username     total activities

raj                    1

gagan               0

meera               3

neel                    0

but am getiing

Username     total activities

raj                    1

meera               3

pls help

i had used Username in dimension and activity count on exp.

and

note:

when am sending report based on GEO wise for india.

according to above 1 user should come if there are 2 users from india 2 users should come. if i check show all value

users from all geo will come. because this report is geo wise pdf report.3 report idf 3 geos. all users from that geo should come irrespective of activities created. geo is been hardcoded in expression as it is pdf requirement.

[alexandros17]

Check the box show all values in dimension and n presentation uncheck "suppress zero values" and "suppress missing"

let me know

[vinay_hg]

sorry my question was not full..

when am sending report based on GEO wise for india.

according to above 1 user should come if there are 2 users from india 2 users should come. if i check show all value

users from all geo will come. because this report is geo wise pdf report.3 report idf 3 geos. all users from that geo should come irrespective of activities created. geo is been hardcoded in expression as it is pdf requirement.

[syukyo_zhu]

you can juste desactivate "supress zero value"

[amit_saini]

Vinay,

Like this/???

Thanks,
AS

[vinay_hg]

yesbut for 1 geo

[amit_saini · Accepted solution]

Check this.

Thanks,
AS