![]() In this result set, the sum calculated for each row in the “Amount Sold” column is the sum of all the sales for that product in that year because the measure column is always at the level defined by the nonaggregation columns in the query. If you change the GROUP BY clause to only group by year, then the sum calculated in the “Amount Sold” column is the sum of each product for the year, and the sum calculated in the SUM(“Amount Sold”) column is total sales of all products for the given year, as follows:Īfter setting the group by year in the advanced tab : Sum(sum("Sales Facts"."Amount Sold") by) saw_3 It is logically the same query as the following: The sum calculated for each row in the sum(Amount Sold) column is the grand total sum. This query returns results grouped by year and category : it returns one row for each product and year combination. “Sales Facts”.“Amount Sold” ( referred in this document as “Amount Sold” )Īnd create a formula column ( referred in this document as sum(Amount Sold) ) : ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |