Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a county information
Here
Country State Values
IND AP 10
IND TS 20
IND KA 30
IND DL 50 in this way
Requirement:
Filters, Country and State.
Country is IND KPI display the 110
If select the state is AP----110-10=100
If select the state is AP,KA ----110-10-30=70 ...
Total - selected values
Only selected values for one KPI --- Ap is state display -10
KA , AP ----30+10
Here some time country info is there ,Some times country info not there in this case find the country for the state.
Thanks
Ram
As below
=sum({<State=>}TOTAL <Country> Values)-sum(Values)
As below
=sum({<State=>}TOTAL <Country> Values)-sum(Values)
Hi Vinieme,
Thanks for your are valuable solution.
It's working fine.
Regards,
Ram