Forum Discussion

elior's avatar
elior
Regular Visitor
2 years ago

Summarize Values To One Column Without Aggregation

Hi,   I have the following tables that I want to add from Table 1 the total summarized values From Table 2 Table1 - number of units bought each hour Table2 - number of items each buyer bought   ...
Need Help
samratpbi's avatar
samratpbi
Super User
2 years ago

sum of all the columns from table 2, i.e. SUM(T2[7]) + SUM(T2[8])...... so on. where I assume 7,8... are the column names in 2nd table T2

elior's avatar
elior
Regular Visitor
2 years ago

the table is dynamic query.

i tried it, but with the same result - aggregation by hour.