1 Reply Latest reply: Jun 15, 2011 1:52 PM by Leonard Short RSS

    Help to display units sold per supplier by store

    Chris Hopkins


      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 count of products sold by supplier by store.




      Coca Cola = 8 products

      Nestle = 4 Products

      Mars = 6 Products.


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


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


      I would appreciate any help