Imagine the data is structures as in Table 1.
I am simply trying to create the same table as Table 2
To do this, I need to firstly calculate the maximum of material needs this and last year
Then I need to summarize these figures by material ID to get the proper total estimated needs.
This may be?
=Sum(Aggr(RangeMax([Last Year], [This Year]), [Storage facility], [Material ID]))
Renamed the fields, so here is the new script:
LOAD [Storage facility],
[Material needs last year] as [Last Year],
[Material needs this year] as [This Year]
(html, codepage is 1252, embedded labels, table is @1);
Community_188377.qvw 149.8 K