total sales by selected sales

[anat]

i have data like:

Country,State,sal

Ind,AP,100

Ind,DL,200

AUS,ST1,50

AUS,ST2,300

need to display :total sales/filtered value 

if no selection: total sales :650

If I make any selection 650/selected sales

if I select AP:650/100

if I select Ind:650/300

i am trying like sum(<Country=,State>sal)/sum(sal),this is working if made any selections,if no selection i am getting 1.

[sergio0592]

Hi,

It should works with  sum({1} sal)  --->650   and sum(sal)  ---> selected sales

[anat]

If no selection made, value coming 650/650

[anat]

any solution pls

[sergio0592]

'If no selection made, value coming 650/650'

Yes, ans what is for you the expected output when no selection made?

[anat]

if no selection made value should be 650/1=650

[sergio0592]

Ok, try :

=if(GetSelectedCount(State)=0 and GetSelectedCount(Country)=0, sum({1} sal) / 1, sum({1} sal) / sum(sal))

[anat]

Thanks for prompt reply, I am also trying same. Looking for alternative solution