Revenue for Customers who bough two Products

[#1]

Hi

I'm wanting to show Top 10 Customers per Revenue in Category A, but only customers who bought products from Category B

Any idea?

I tried this:

sum({<ProdCode={"sum({<ProdCode={'A'}>0 and sum({<ProdCode={'B'}>0"}>} Amount)

but it's returning No data to display

Any ideas?

[MayilVahanan · Accepted solution]

Hi

May be, try some thing  like this

Customer as Dimension:

sum( {<Customer = P({1<ProdCode={‘B’}>} Customer), ProdCode = {'A'}>} Amount)

In dimension limit, select Show only Largest 10 values

[jagan]

Hi,

Try like this

sum({<Customers = P({<ProdCode={'B'}>})}, ProdCode={'A'}>} Amount)

Regards,

Jagan.

[lironbaram]

you can use something like

sum({<customerID=p({<ProdCode={"B"}>}customerID)>}Sales)r

this expression calculate sales only for customers who purchased something in category b

hope it helps you