The two metrics come from the same fact table, so in the SQL view there is just one SELECT
statement with both count(1)
and sum(a11.SalesAmount)
.
See the image for results:
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.