Hi,
I am facing aggregation issue while grouping reports in webi.
We have a BW query with 16 values, which we bring to bw as structure. Out of 16, 8 are percentage values (agg. type should be average).
If we bring the data at site level, data is comming properly. But if we use same query and try sum/grouping( on region level), then percentage is getting added.
Since it's a dashboard report with lots of filters, we cannot go for seperate query at each level(site, region, zone).
How we can resolve this.. please give me suggestion.
Regards
Baby