5 Replies Latest reply: Jul 24, 2015 5:10 AM by Alexander Steinhart RSS

    use only parts from selections for the calculation

    Alexander Steinhart

      Hi,

      I'm new her. I hope it's the correct place for my question.

       

      I have a 'Straight Table' with two dimensions. And I need 3  Expressions. You can see a example her:

       

      Dimension1Dimension2Expression1Expression2Expression2
      =sum( {$<SalesYear={'2011'},>}  Sales)=???????=???????
      ProductCustomer

       

       

      Sales 2011


      total Customers Sales 2011total Product Sales 2011

      P1

      C15 5+6=115+2=7

      P2

      C16 5+6=116+4=10
      P1C22 2+4=65+2=7
      P2C24 2+4=66+4=10

       

      Row one and two are for explanation.

      My problems are the formulas for expression 1 and 2 

      There should be no influence of Listboxs to my Expressions. Only in Expression1 is it ok.


      I hope you can help me. Thanks

      Alex