Hi all,
I have a problem with the inputsum() aggregation.
i cannot use it somehow.
this is the script:
INPUTFIELD FactTable.test;
FactTable:
LOAD Date,
[Acc code],
Value as test
FROM
[DC.xlsx]
(ooxml, embedded labels, table is Blad1);
Descr:
LOAD [Acc code],
Descr
FROM
[DC.xlsx]
(ooxml, embedded labels, table is Blad2);
Calendar:
Load Date,
Year(Date)&'-'&Month(Date) as YM
RESIDENT FactTable;
when i change INPUTFIELD to just "test", it says it creates duplicate keys so it doesnt work.
Can anyone help me?
dashboard with source is attached.
Best regards,
Dick
