2 Replies Latest reply: Mar 7, 2013 5:28 AM by Nicholas Child RSS

    Totals with Set Analysis, bug or am I stupid?

      Hi all,


      I've got this expression to work out Total Market Share, trying to get it to work with a total for each month in a line chart.


      My expression:

                sum({<Category=,Manufacturer=,Brand=,[Pack Size]=,[Pack Type]=,Barcode=,Description,SizeDesc,Packs=>}total(<[Chart Periods]>Value))


      The weird thing is at the top of the expression editor it says: "Expression OK" but in the actual expression there is a red squiggly line under the last bracket (see above)


      Is my syntax wrong?


      Any help would be appreciated.


      Tx, Cindy