6 Replies Latest reply: Jun 15, 2011 11:35 AM by Chris Hopkins RSS

    Expression help to show units sold per supplier.

    Chris Hopkins

      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