Suppress Calculation of Qty

[Anonymous]

Hi,

I am attempting to create a list of customer's special prices, the quantity they need to purchase and the quantity that they have purchased since they received their special price.

I have made a straight table chart to produce the attached image, in it there are two lines of 300 meaning the customer has purchased 600 units - In total the customer has only ordered 300 units. Is there a way to suppress the qty expression until the last record is found?

Regards

David

[devarasu07]

Hi,

can u share the expression that u r using this chart.

you can also try to exclude null in below ways

Suppress null value in your customer ID dimension

or try to exclude using set analysis

sum( {$<CustomerID={"=len(trim(CustomerID))>0"}>} OrderQty)

[Anonymous]

Hi,

My expression is - Sum (if ([Starting Date]>= Date,[Quantity]))

Regards

David