Forum Discussion

ziqh's avatar
ziqh
Frequent Visitor
8 years ago

Summarising rows in calculated table

Hi All,   Stuck on an issue that I'm almost certain is a simple one.   I have two tables of data, and I've taken them to a single calculated table via a UNION, like so: CalcTable = UNION(       ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI ziqh

 

The UNIOIN function just combines teh data and it wont aggregate, so the output of UNION is expected one.

 

For your desired result, you need to Wrap your UNIONed query with a SUMMARIZE function.

 

Thanks

Raj