Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please note that my revenueid is from other table.
Hi..
Take three dimension chart expressions .
sum(state)
count(country)
sum([revenue id]=6789)
try once ..
Thanks ,
Sreenu
Hi Durga,
Like this????
Thanks,
AS
Hi Sai,
Can you please share screenshots. I have no access to open the .qvw file.
Thanks,
Durga