Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a excel sheet that sheet contains requirement like...
in my table i have fields like Country, State, City,Village, and ID. So my requirement is first when i select india in Country field and next select Maharashtra in State field and select Mumbai in City field, and Select Ghansoli in Village field i will get a value like 120 (Count(ID)).
After that i select Mumbai and Pune in City field i got a value like 130(Count(ID)).
After that i added two values like 120+130=250 will be coming, The 250 is the value of "Complete required ".
I need to display these vales on Table.
The sample out put is:
So tell me how can i achieve this..
Thanks advance
Can you share sample data, not sure but may be you need to use set expression like this -
Count({<Country={'India'},State={'Maharashtra'},City={'Mumbai'},Village={'Ghansoli'}> + <Country={'India'},State={'Maharashtra'},City={'Mumbai','Pune'}>}ID)