Expression for Total in Set Analysis

[umartareen]

Hi,

I want to find the total value of the expression (Quantity * Price) and display it in the Gauge-LED chart. What would be the expression to do so ? Please find attached.

Thanks in advance

Regards

Umar

[ashfaq_haseeb]

Hi,

Try below

sum(Total Quantity * Price)

Regards

ASHFAQ

[umartareen]

Thank You Ashfaq, but it still didn't produce the output.

[#4]

Have you tried something like:

=SUM(AGGR(SUM(SUM([Quantity]) * [Price]),[ProdName]))

This will work if your product is always sold at the same price. If the price can vary you want to add in a dimension with appropriate granularity, something like:

=SUM(AGGR(SUM([Quantity] * [Price]),[ProdName],[Order#]))