Hello,
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.
You have anyone in this situation?
PS: we cannot do the operations by script.
Thank you.
