Expression help to show units sold per supplier.

[hopkinsc]

Hi,

I need some help with an expression...

I have an application which shows promotional deal sales per store. We are currently running a deal (Lunch Time Special) which comprises of:

1. Any sandwich / Baguette

2. Any drink 330ml

3. A choice of either a chocolate bar or any pack of crisps.

We then give the store a bonus for each deal sold, but the bonus amount is different depending on the products sold.

I want to show in my application a breakdown of the products sold per supplier at store level for the selected deal.

I have attached an example of my application. I would like this expression to appear in the SUMMARY chart.

I would appreciate any help

Thanks

Chris

[hopkinsc]

Hi, i have just noticed that i have made a mistake in my post..

When i say..

I want to show in my application a breakdown of the products sold per supplier at store level for the selected deal.

What i mean is

I want to show in my application a count of products by supplier by store.

E.g

Coca Cola = 8 products

Nestle = 4 Products

Mars = 6 Products.

I will probably have to use a PIVOT chart instead of a straight Table.

Thanks

[hopkinsc]

Hi everyone, Any ideas on my query would be very helpful

[hopkinsc]

Any Ideas?

[hopkinsc]

Hi, is what i want to do not possible?

[#6 · Accepted solution]

Hi hopkinsc

Here an example with 2 pivot tables.

Let me know if this help you.

Regards!

[hopkinsc]

Hi Emmanuel, i feel so stupid now!! i don't know why i didn't think of doing that. I only had to add the Supplier field to my existing chart and change it to a pivot table.

Thanks very much for your help...