Help me in writing expression for barchart?

[durgabhavani]

Hi All,

I have scenario like below

I have one dimension country
it has number of states if i click on one country it should number of states based on revenueid

My dimension:
country
india
us
united kingdom
hong kong
china
ireland
srilanka

Expression need to contain below two fields:

States
26
24
15
23
10
7
11

Revenue id
1228
1234
2345
4567
6789
1345
8923
9089
999
12

Now i want to display the results on barchart when i click on country it should show the number of states where revenue id is equal to 6789?

Please advice.

Thanks,
Durga

[durgabhavani]

Please note that my revenueid is from other table.

[#3]

Hi..

Take three dimension chart expressions .

sum(state)

count(country)

sum([revenue id]=6789)

try once ..

Thanks ,

Sreenu

[amit_saini]

Hi Durga,

Like this????

Thanks,

AS

[durgabhavani]

Hi Sai,

Can you please share screenshots. I have no access to open the .qvw file.

Thanks,

Durga