Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have columns Orderno, Country, SalesQty, SalesAmount,ItemNo_, BrandName.
Now I want use BrandName as dimension and In one expression I would like to get count of all No items belongs to that brand and 2nd expression how many are sold in particular country.
Example. Brand is Givenchy and it sells 100 products this is first expression, and In 2nd expression I would like to see how many of these 100 item sold in UK lets say 40.
example results:
Brand | No.Total Available Item | No. of Items sold in UK |
---|---|---|
Givenchy | 100 | 40 |
Thank you in advance.
Try like:
Exp1: Count( Distinct ItemNo_)
Exp2: Sum({<Country={'UK'}>}SalesAmount)
Hi Tresesco,
In Exp 2 ,I want to count how many item sold but not the amount. Is that correct in that expression and If I want to and another country let's say USA can I add it as well?
you can use ,
Aggr( Count(ItemNo_),Country,BrandName),
share sample .qvw
May be try tresesco's 2nd expression like this
Count(Distinct {<Country={'UK'}>} ItemNo_)
Yes, like:
Exp2: Count({<Country={'USA'}>} Distinct ItemNo_)
Both Sunny's and Tresesco's Exp 2 are working.
Thank you