Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
It should works with sum({1} sal) --->650 and sum(sal) ---> selected sales
If no selection made, value coming 650/650
any solution pls
'If no selection made, value coming 650/650'
Yes, ans what is for you the expected output when no selection made?
if no selection made value should be 650/1=650
Ok, try :
=if(GetSelectedCount(State)=0 and GetSelectedCount(Country)=0, sum({1} sal) / 1, sum({1} sal) / sum(sal))
Thanks for prompt reply, I am also trying same. Looking for alternative solution