Hi WebI Gurus,
Is it possible in WebI, based on a universe, not using FHSQL, nor Derived tables, to get the following SQL syntax in a WebI Query:
from Fact_Transactions t
max (ActivityDateTime) maxliqDate
where ActivityType = 3
group by AUserAccountId]) ppp
group by t.UserAccountId
This should get the sum of payments issued to an account from the last activity date of each user.
Assuming the universe does not have an object for each calculation, for example - max (ActivityDateTime), since these dates are determined at the report level, can this be achieved with just the WebI query panel?
Thanks in advance for any comments