10 Replies Latest reply: Dec 16, 2013 9:38 AM by Julio Lourenco RSS

    Graphic with values from 2 different lists

      Hi folks, i need some help here.


      I have 2 sheets with data, 2 lists (OPTIONAL and OPTIONAL_DESIRED) to filter that data's and i also have a list mixing those 2 lists (let's call this 'Wanted list').


      I need a graphic that shows me both selections, list 1 plus list 2, i need the graphic to do the same thing as the Wanted list does plus providing me the sum of the costs for each optional.

      And also, if i select the same optional from list 1 and 2, the cost doesn't change twice.


      I'm attaching my XLS and my QVW, and I've already selected some values, and as you'll be able to see, the graphic show me both but the cost is totally wrong.


      Thank you in advance!


      PS: you need to change the path at the script:


      [xxxx\data config.xlsx]

      (ooxml, embedded labels, table is F1);'