Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Hi,
My expression is - Sum (if ([Starting Date]>= Date,[Quantity]))
Regards
David