2 Replies Latest reply: Oct 17, 2012 8:18 AM by claypot3 RSS

    How do I force a calculation at a level not displayed

      I have a complex data structure, as most people do - I have Deals that have multiple Items,  the Deals also have multiple Categories (I call them details in the attached qvw).  I need to create a factor using the weights in the Categories them mutiply it by the Item Amounts.


      When all the dimension data is displayed, I'm able to get the correct total.


      When I drop some of the dimensions, the math changes -  How do I create an expresion to force the factor to ALWAYS take the sum of the weights selected for a deal and divide by the total weight of the deal?


      I'm new to QV and have tried several options but have not come close!  Any ideas or help would be appreciated.