Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
What does SUM(total <Month> sales) exactly mean??
I am using sum(sales)/SUM(total <Month> sales but not getting the desired output.
Kindly suggest??
Regards,
Rohit
Hello Rohit,
The dimension between angular brackets will be taken into account for the aggregation expression, instead of the aggregation for all dimensions. In your example, the sum will add only for the Month dimension.
Hope that helps