Any help would be greatly appreciated!
I have created KPI's in Controller 8.5 using AFC's
Some of my sites which need these KPI's calculated before they submit the data are not in a group and hence have no ability to consolidate, my AFC's only work when a consolidation is run.
I cannot show the sites the group above as they then get to view the groups data in the forms.
The only option I have is to create a flat tree structure especially for the KPI's but this thought is not very appealing.
I cant think that this is such an uncommon issue for it not to be possible - but I cannot think of a work around does anyone have any suggestions?