Hi,
Need to display the %age Collection of the collector i.e. out of the total collection made by all the collectors in an Agency, how much collection is made by the selected collector.
in this case, % should be 10/100= 10% as 10 is the amount of collector a1, and the total collections by all collectors in Agency1 is 100.
I need to give both the selections as filters in my dashboard.
I am able to do this by making a Parameter of Collector. But need to achieve this with a filter as the tagging of a collector with an Agency is not consistent and keeps changing. In order to avoid the manual intervention of updating the parameter again and again in the Production environment, I want to achieve this by filters.
Regards,
Manu
Manu,
Before 9.0, you can do it with duplicating the data sources.
You put calculated field on 2nd source,
[sum_Amount(Agency)]
sum([Amount])
Then, because you need "Agency" level summary, you only link two data with "Agency", not link with "Collector".
Go back to primary data source and calc normal sum(amount).
But [percentage] should be
sum([Amount])/[Data (Percent of total) (copy)].[sum_Amount(Agency)]
Actually this is 2nd or 3rd time I'm putting similar solution in this community... Please share.
Thanks,
Shin
8.3 attached.
