I have a table with a formula that performs a summation with aggr by customer, user and hierarchy of material.
In the dashboard have several fields that we can filter out part of the 3 courses we have in the aggr the formula.
The problem arises because the data shown in the table are different depending on the filters that select, if I do not select a material might result appears me and if I select it gives me another.
Selected Material:
Period
Material
Result
2016_10
xxxxx
100 E
Unchecked Material:
Period
Material
Result
2016_10
xxxxx
53 E
2016_10
yyyy
102 E
2016_10
zzzzz
10 E
This behavior occurs because the aggregation is not taken into account that field, but the problem is that there are about 30 fields that can filter and cannot put all the fields in the aggr by theme perfomance.
I think it would be easier to help if we can have a sample to look at. Its difficult to say what might not be working. Would you be able to share a sample or at least some raw data?
